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

Hide the sheet using the format>sheet>hide and then protect the workbook
using tools>protection>workbook 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
>
>

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