Password On Sheet Only

  • Thread starter Thread starter Phyll
  • Start date Start date
P

Phyll

I need to password one sheet out of a book of sheets from
being viewed. I want one sheet that you cant view with
out a password. Any Ideas?
 
Format the sheet as xlVeryHidden using VBA (Or just change it's properties in the VBE), then
protect the VBA project with a password. That way most people will never even know it exists, let
alone be able to unhide it.
 
This looks like an interesting issue to me. Understand I
am new to Excell.

Can U kindly give me step by step instructions on how to
use VBA to achieve this (I assume VBA is visual basics)

Thanks in advance
omer

-----Original Message-----
Format the sheet as xlVeryHidden using VBA (Or just
Click to expand...
change it's properties in the VBE), then
protect the VBA project with a password. That way most
Click to expand...
people will never even know it exists, let
 
You can do it without VBA (Sort of - You just won't have to write any code, but you do need the
VBE):-

With your spreadsheet open:-

Hit ALT+F11 and this will open the VBE (Visual Basic Editor)
Top left you will hopefully see an explorer style pane. Within this pane you need to search for
your workbook's name, and when you find it you may need to click on the + to expand it. Within
that you should see the following:-

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
ThisWorkbook

Assuming Sheet 2 is the one you want to hide, left click once on Sheet2 above

You should now see in the window below that, a whole bunch of properties for that sheet, starting
with:-

(Name)
DisplaypageBreaks
DisplayRightToLeft
....
....
Visible

Click on the visible Property and then use the dropdown in the field on the right of it to select
the xlveryHidden option.

Once this is done, right click on the bit that says VBAProject(Your_Filename) and then left click
on the VBAProject properties option, and then on the dialog box that appears, select the
Protection Tab. Now just check the 'Lock prpject for viewing' option, put in a password and away
you go.
 
Thanks a bunch

-----Original Message-----
You can do it without VBA (Sort of - You just won't have
Click to expand...
to write any code, but you do need the
VBE):-

With your spreadsheet open:-

Hit ALT+F11 and this will open the VBE (Visual Basic Editor)
Top left you will hopefully see an explorer style pane.
Click to expand...
Within this pane you need to search for
your workbook's name, and when you find it you may need
Click to expand...
to click on the + to expand it. Within
that you should see the following:-

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
ThisWorkbook

Assuming Sheet 2 is the one you want to hide, left click once on Sheet2 above

You should now see in the window below that, a whole
Click to expand...
bunch of properties for that sheet, starting
with:-

(Name)
DisplaypageBreaks
DisplayRightToLeft
....
....
Visible

Click on the visible Property and then use the dropdown
Click to expand...
in the field on the right of it to select
the xlveryHidden option.

Once this is done, right click on the bit that says
Click to expand...
VBAProject(Your_Filename) and then left click
on the VBAProject properties option, and then on the
Click to expand...
dialog box that appears, select the
Protection Tab. Now just check the 'Lock prpject for
Click to expand...
viewing' option, put in a password and away
 
Back
Top