Want to stop users accessing a worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 29 Dec 2003 09:43 GMT

I have 2 Worksheets within a excel doc,
I have sensitive data in the 2nd worksheet,
I want to hide it (Which i can do),
But want to stop users from unhiding it,
Is there anyway to do this without moving the 2nd worksheet
to a seperate excel file??
Cheers
Chris

Reply to this Message

Norman Harker - 29 Dec 2003 09:54 GMT

Hi Chris!

Hide the sheet
Tools > Protection > Protect Workbook
Give and confirm a password

You'll see now that the Format > Sheet menu has hide and unhide grayed
out.

But be aware that this is not a very secure form of protection and
that the passwords are very easily broken by those who do a Google
search and find the code and workbooks that are available.

Signature

Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

> I have 2 Worksheets within a excel doc,
> I have sensitive data in the 2nd worksheet,
[quoted text clipped - 4 lines]
> Cheers
> Chris

Reply to this Message