Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Icon
How about adding password protection to the workbook? That should prevent
users from seeing hidden worksheets, etc. Give it a try. HTH, Eric "Doug" wrote: I have a workbook with 5 sheets and 5 userforms. The user is supposed to have access to 1 form. All the sheets are locked or unlocked as required to perform various proceedures. Only the administrator should have access to the various sheets and input forms. This access is password protected. The code I used to lock everything was: ActiveSheet.Protect Password:=TheWord, Contents:=True, Scenarios:=True, _ DrawingObjects:=True ActiveSheet.Unprotect Password:=TheWord The problem is, the Format Icon on the Excel toolbar is still active which gives the user access to 'unhide sheets' This exposes the other sheets which are locked, but the command buttons are now visible and active which gives the user full access to everything. Is there code I can add to mine so I can deactivate the Format icon to limit user acess? Thanks for the help. Doug |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Format icon | Excel Discussion (Misc queries) | |||
Is it possible to create a customised conditional format icon in e | Excel Worksheet Functions | |||
remove Format painter icon on speardsheet | Excel Discussion (Misc queries) | |||
Using Conditional Format/Icon Set With Dates | Excel Worksheet Functions | |||
How do I format the Currency Icon in Excel 2007? | Setting up and Configuration of Excel |