Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ....) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ....) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Protection Question | New Users to Excel | |||
Protection Question - Help Please | Excel Discussion (Misc queries) | |||
Sheet protection question | Excel Discussion (Misc queries) |