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
|