disable read-only on a protected worksheet

  • Thread starter Thread starter raul duke
  • Start date Start date
R

raul duke

Is there anyway to maximize protection on a single sheet
by disallowing viewing the sheet through passwords. Or is
the only option to allow access but maintain read-only
permissions.
 
Couple of ideas:

You could set the sheet visibility to xlveryhidden. This way it won't be
possible to unhide it via the menus.

worksheets(1).visible=xlveryhidden


Maybe put the secure sheet in a workbook of it's own and link to it.
Protect the workbook appropriately in with the file system. Will only be
applicable in certain situations.




--
Regards,


Bill Lunney
www.billlunney.com
 
Search for 'Require a password to open a workbook' in help
menu (F1). This will only allow you to open the workbook
with a password.

HTH
Mike
 
Back
Top