disable read-only on a protected worksheet

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.
 
B

Bill Lunney

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
 
M

Mike

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Password protecting multiple pages, and then some. 7
vba solution for protection 3
Protected Sheet - Using Groups without a Macro 1
Can't insert a new worksheet 8
How can I protect a sheet so the rows/columns can't be deleted? 1
allow a user to edit ranges in a protected worksheet 3
Protecting sheets with drop down boxes 0
Excel Office 2007 Password protect worksheet 1

Top