sheet protection question
 

I have a spreadsheet with buttons to copy information from cell to
cell. However, my users insist on ignoring the buttons and using
copy/paste themselves and invariably they mess up the cell names.

How would you protect the sheet so that the only way to manipulate the
contents of the spreadsheet is via the buttons I have provided for
them? thanks in advance ...
Larry Levinson
Talking up to the vocal ...
LLevinson*Bloomberg.net
(remove the star etc ....)

sheet protection question
 

try
protecting the sheet and having the macro unprotect and do it's thing &
re-protect

"Larry Levinson" wrote in message
...
I have a spreadsheet with buttons to copy information from cell to
cell. However, my users insist on ignoring the buttons and using
copy/paste themselves and invariably they mess up the cell names.

How would you protect the sheet so that the only way to manipulate the
contents of the spreadsheet is via the buttons I have provided for
them? thanks in advance ...
Larry Levinson
Talking up to the vocal ...
LLevinson*Bloomberg.net
(remove the star etc ....)