Thread: Protect
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Protect

You can always hide the tabs
Select first tab, hold don Ctrl key select last tab
Format - Sheet - Hide
When it's protected, can't unhide them.

"Kim" wrote:

I tried that first and it still opens the workbook without a providing a
password. Do I need to lock cells or certain tabs individually then protect
the workbook?

"Sean Timmons" wrote:

Tools - Protection - Protect Workbook

"Kim" wrote:

How can I save a workbook so that the only way to open it is with a password.
It is on a share drive and I only want certain managers viewing the
information.

Thanks!