View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default 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