Block sheet entirely....

  • Thread starter Thread starter Sonnich
  • Start date Start date
S

Sonnich

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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting name of sheet 3
How to hide password? 1
Date formattting in Excel when using OLE 1
Newbie questions - probably simple 4
password protect individual sheets 1
Protecting data on a sheet 3
Print entire workbook with each sheet starting at page 1 8
Protecting multiple sheets 4

Back
Top