| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to prevent adding sheet in a workbook.
"Tom Ogilvy" wrote in message
... Just some added thoughts. Rob's method could of course could be easily defeated through overt action by the user to break the protection. Jim's method (like any software based protection) could be inadvertently defeated by setting security to high and the user would never know you cared whether worksheets were added or not. Yes, of course. Clearly, applying a strong file-open password to the workbook and then not supplying the user with that password would be a more robust method of preventing new worksheets from being added. ;-) -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent users to use a workbook/sheet after a specified day | Excel Worksheet Functions | |||
| need to modify a macro to prevent it from executing if in wrong area of the sheet | Excel Discussion (Misc queries) | |||
| Can I prevent a sheet from moving within a workbook? | Excel Programming | |||
| Can I prevent a sheet from moving within a workbook? | Excel Programming | |||
| How to prevent pasting to every sheet in workbook | Excel Programming | |||
Threaded Mode
