| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Spreadsheet Protection
Hello,
I have a protected Excel spreadsheet that is available for use by a large population. I would like to allow users to manupulate any saved copies. Currently, when you save a copy to your personal desktop the protection is still active and users can not make the spreadsheet their own. How do I protect the original document but allow user manipulation of copies? -- Michael J. Nowak Energy Systems/Dow Chemical Texas City, TX |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Spreadsheet Protection
Mike,
You could use the _BeforeSave event to check if it a .Save or .SaveAs. If .Save, do nothing as it updating the original. If .SaveAs, remove the protection of the worksheet(s) first. NickHK "Mike" .(donotspam) wrote in message ... Hello, I have a protected Excel spreadsheet that is available for use by a large population. I would like to allow users to manupulate any saved copies. Currently, when you save a copy to your personal desktop the protection is still active and users can not make the spreadsheet their own. How do I protect the original document but allow user manipulation of copies? -- Michael J. Nowak Energy Systems/Dow Chemical Texas City, TX |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Spreadsheet Protection
Nick, thanks for the reply. I am assuming you are talking about writing
macro code to checkthese conditions. I am not a real expert at that. Do you have any more specific details on how I might accomplish this? -- Michael J. Nowak Energy Systems/Dow Chemical Texas City, TX "NickHK" wrote: Mike, You could use the _BeforeSave event to check if it a .Save or .SaveAs. If .Save, do nothing as it updating the original. If .SaveAs, remove the protection of the worksheet(s) first. NickHK "Mike" .(donotspam) wrote in message ... Hello, I have a protected Excel spreadsheet that is available for use by a large population. I would like to allow users to manupulate any saved copies. Currently, when you save a copy to your personal desktop the protection is still active and users can not make the spreadsheet their own. How do I protect the original document but allow user manipulation of copies? -- Michael J. Nowak Energy Systems/Dow Chemical Texas City, TX |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auditing Spreadsheet Protection | Excel Discussion (Misc queries) | |||
| Protection of spreadsheet | Excel Discussion (Misc queries) | |||
| Password Protection on Excel Spreadsheet | Excel Worksheet Functions | |||
| how to remove protection from a spreadsheet | Excel Discussion (Misc queries) | |||
| spreadsheet protection? | Excel Worksheet Functions | |||
![Mike[_109_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
