Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can hidden sheets be prevented from opening without a password?
I want to prevent a worksheet being viewed by other users of the workbook.
Can this be done by, say, password protection, as can be done in Word? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can hidden sheets be prevented from opening without a password?
Yes.
Hide the sheet, then Tools/ Protection/ Workbook -- David Biddulph "unclepablo54" wrote in message ... I want to prevent a worksheet being viewed by other users of the workbook. Can this be done by, say, password protection, as can be done in Word? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can hidden sheets be prevented from opening without a password?
Hi unclepablo54,
It certainly can. In Excel 2007, you would first hide the sheets that you want to remain hidden. Then click "Protect Workbook" from the "Review" section of the ribbon. You click on "Protect the Structure and Windows" and leave "Windows" ticked. Enter your password and your workbook is protected. Users cannot unhide the sheets without the password. I hope this helps. Cheers, Nick -- Nicholas Perkins Excel Analyst, Designer and Programmer http://www.nicholasperkins.com/ is bad.com (Please remove the spamisbad) "unclepablo54" wrote: I want to prevent a worksheet being viewed by other users of the workbook. Can this be done by, say, password protection, as can be done in Word? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a group but keep hidden rows hidden | Excel Discussion (Misc queries) | |||
Password protect a hidden tab | Excel Discussion (Misc queries) | |||
Excel 2003 spreadsheet saving prevented by violation error | Excel Discussion (Misc queries) | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
how can I password hidden columns | New Users to Excel |