Protecting worksheet

[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

 

[Frank Kabel]

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)

 

[Norman Harker]

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.