Hi,
I have picture buttons I have assigend macros to. The first, when clicked on, adds a row. The second deletes a row.
If the user puts the cursor in the wrong cell before clicking on either 'button', they delete the wrong row and corrupt the file. They could only recover it by closing the file without saving changes, and re-opening it - which is not an ideal solution.
Is there a way to link the macro-assigned picture buttons to specific cells so that if the user has the cursor in the wrong cell, the buttons won't work and a message tells them what to do? The soltion would also have to refer to non-relative cells since, as a row is added or deleted, it changes the cell's number by +/- one.
Thanks,
Dom
PS. If this is not clear, let me know and I'll explain better!
I have picture buttons I have assigend macros to. The first, when clicked on, adds a row. The second deletes a row.
If the user puts the cursor in the wrong cell before clicking on either 'button', they delete the wrong row and corrupt the file. They could only recover it by closing the file without saving changes, and re-opening it - which is not an ideal solution.
Is there a way to link the macro-assigned picture buttons to specific cells so that if the user has the cursor in the wrong cell, the buttons won't work and a message tells them what to do? The soltion would also have to refer to non-relative cells since, as a row is added or deleted, it changes the cell's number by +/- one.
Thanks,
Dom
PS. If this is not clear, let me know and I'll explain better!