View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ufo_pilot ufo_pilot is offline
external usenet poster
 
Posts: 142
Default Protecting Worksheets

You can hide the sheet
FormatSheetHide
then password - protect the workbook


"Kaitlin.uk" wrote:

I have multiple worksheets in one workbook. Can i protect just one worksheet
within the book so that it cannot be viewed at all.

so when you click on the tab it asks for a password? instead of just
protecting all the cells?

thanks