Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block sheet entirely....
Hi
Is there a way, to have a sheet, which the (end) user cannot see at all? I was thinking of something like OnAllowChange, like in Delphi, to block users from even seeing a sheet(3) on my doc, unless they have a password. Is that possible? The OnActivate fires _after_ the page is displayed. BR Sonnich |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block sheet entirely....
Hide the sheet using the formatsheethide and then protect the workbook
using toolsprotectionworkbook using a password if you want -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Sonnich" wrote: Hi Is there a way, to have a sheet, which the (end) user cannot see at all? I was thinking of something like OnAllowChange, like in Delphi, to block users from even seeing a sheet(3) on my doc, unless they have a password. Is that possible? The OnActivate fires _after_ the page is displayed. BR Sonnich |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block sheet entirely....
You could put something like
Sheets("Sheet3").Visible = xlSheetVeryHidden in the Workbook_Open event, and display an input box for a password, and use the response to toggle if the sheet get hidden/unhidden. hth Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to reference a block of cells from another sheet. | New Users to Excel | |||
Block Printing of sheet | Excel Discussion (Misc queries) | |||
Insert A Block of Data Into Another Sheet | New Users to Excel | |||
Block an area of sheet from Printing? | Excel Discussion (Misc queries) | |||
Block an area of sheet from Printing? | Setting up and Configuration of Excel |