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

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

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