Hi

You can set sheet(s) to be Very Hidden in VBA-Project window (Alt+F11,
select the sheet in leftmost upper window, and edit Visible property). When
the sheet is very hidden, it doesn't appear in list of sheets to unhide in
FormatSheet menu.

When in VBA editor, you also can after setting the sheet to be very hidden
protect your VBA project with password - so other users can't open it to set
sheet(s) visible manually (at least not without some cracking)


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"Lee Harris" wrote in message
...
Is it possible to hide sheets but prevent users from just unhiding them
from the Excel main menu? either they can't do it or need a password for
example?

Likewise, what is the correct way to lock off cells in different sheets so
that only certain cells accept data and the user can't just unlock the
other cells

cheers