Prevent Buttons From being Copied

CB_DFW

Registered User.
Local time
Yesterday, 18:05
Joined
Nov 5, 2008
Messages
30
I have a spreadsheet that has several buttons on it. Users are going to try and copy all the data from this spreadsheet and paste it to a new sheet in another spreadsheet and it's going to copy the buttons. These buttons will not work if they are copied to a different tab.

Is there a way to keep them from being copied when they try and copy the sheet?

Thanks

I have attached a sample file. See the tab named "Region".
 

Attachments

Open the properties of each button and place a check in "Don't Move or Size with cells" and then save it.

I should add that this will only keep the buttons from being Copy/Pasted if the cells are being copy/pasted as you described.

However, if your users perform a "move or copy" on the whole worksheet, the buttons will also be moved or copied.
 

Users who are viewing this thread

Back
Top Bottom