Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing other users from opening hidden worksheets
I have a workbook to which only i have the password. All other users open it
as "read only". Within the book are some hidden worksheets. However, even when the book is opened as "read only", a user is able to unhide these sheets. I've tried using "Tools-Options-View-Hide Tabs" & "Format-Sheet-Hide", all to no avail. Is there an easy way I can prevent this? thanks in anticipation. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing other users from opening hidden worksheets
Hi
Open VBA Editor (Ctrl+F11). Usually there will be VBA-Project Explorer window, Properties window (both at left), and Code window (at right) opened. When Properties window is closed, you can open it from View menu (Excel 2000). In VBA Project window, select the sheet, you want to hide, and in Properties window, set it's Visible property to xlSheetVeryHidden. Now the user can make this sheet visible only from VBA-Project Properties window. To prevent users meddle with VBA Project Properties too, right-click on your VBA project in Project window (the object with your workbook name is brackets), select VBA Project properties from drop-down, activate Protection tab, check 'Lock Project from viewing', and set password. (Store the password somewhere, or you may have some trouble later) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "pjk@boro" wrote in message ... I have a workbook to which only i have the password. All other users open it as "read only". Within the book are some hidden worksheets. However, even when the book is opened as "read only", a user is able to unhide these sheets. I've tried using "Tools-Options-View-Hide Tabs" & "Format-Sheet-Hide", all to no avail. Is there an easy way I can prevent this? thanks in anticipation. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing other users from opening hidden worksheets
Be aware that password protection is extremely weak in Excel. Any user who
wants to can get at the hidden sheets, no matter how hidden, if they want to. If a user should not see the data, then don't send it to them. Robert Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "pjk@boro" wrote in message ... I have a workbook to which only i have the password. All other users open it as "read only". Within the book are some hidden worksheets. However, even when the book is opened as "read only", a user is able to unhide these sheets. I've tried using "Tools-Options-View-Hide Tabs" & "Format-Sheet-Hide", all to no avail. Is there an easy way I can prevent this? thanks in anticipation. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preventing other users from opening hidden worksheets
Protect the workbook under ToolsProtectionProtect Workbook.
After you have hidden the sheet, that would be. See Bob's caveat about Excel security. Gord Dibben MS Excel MVP On Fri, 30 May 2008 02:35:01 -0700, pjk@boro wrote: I have a workbook to which only i have the password. All other users open it as "read only". Within the book are some hidden worksheets. However, even when the book is opened as "read only", a user is able to unhide these sheets. I've tried using "Tools-Options-View-Hide Tabs" & "Format-Sheet-Hide", all to no avail. Is there an easy way I can prevent this? thanks in anticipation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PREVENTING ACCESS TO A HIDDEN COLUMN | Excel Discussion (Misc queries) | |||
I have an xla file preventing me from opening new files | Excel Discussion (Misc queries) | |||
Preventing users from unsharing a workbook | Excel Discussion (Misc queries) | |||
Preventing other users saving another version of protected workboo | Excel Discussion (Misc queries) | |||
Preventing users from saving a spreadsheet | Excel Discussion (Misc queries) |