Protecting worksheet

  • Thread starter Thread starter alexm999
  • Start date Start date
A

alexm999

I have a file with 3 worksheets. Can I make 2 out of the 3 worksheet
"invisible" or something that users cannot get into those worksheets
 
Hi
one way (though this is not fool-proof but will prevent 'normal' users
from entering your hidden worksheets
- select the sheets
- goto 'Format - Sheet' and hide the sheets
- goto 'Tools - Protection' and protect your workbook (you may choose a
password for this)
 
Hi alexm999

Hide first then use:

Tools > Protection > Protect Workbook
Give and confirm password [optional]
OK

But be aware that passwords for Excel internal protection are easy to
circumvent and you might best regard it as allowing protection against
accidental changes to those sheets or for aesthetic purposes.

See for example:
http://www.mcgimpsey.com/excel/removepwords.html
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top