Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect a worksheet with a password
I have 20+ worksheets in a single workbook - I want to protect only one of
those worksheets with a password. (I don't want anyone to be able to view that specific worksheet unless they have the password.) How can I do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect a worksheet with a password
Viewing a worksheet is not prevented by password protecting it. Try
something like this. If Sheet2 should be the "culprit": right-click the sheet tab for Sheet2, select View Code, Put this code in: Private Sub Worksheet_Activate() With ActiveWindow .Windowstate=xlminimized If inputbox("Password?") < "Putyourpasswordhere" Then Sheets(1).Select .Windowstate=xlmaximized End With End Sub Bob Umlas Excel MVP "colettey29" wrote in message ... I have 20+ worksheets in a single workbook - I want to protect only one of those worksheets with a password. (I don't want anyone to be able to view that specific worksheet unless they have the password.) How can I do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect a worksheet with a password
You can hide the sheet using FormatSheetHide.
Then Protect the Workbook(not worksheet) for Windows and Structure. NOTE: password protection in Excel is easily cracked so don't use this method if the sheet data is sensitive. Gord Dibben MS Excel MVP On Tue, 26 Sep 2006 08:30:02 -0700, colettey29 wrote: I have 20+ worksheets in a single workbook - I want to protect only one of those worksheets with a password. (I don't want anyone to be able to view that specific worksheet unless they have the password.) How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I password protect a hidden column in Excel? | Excel Worksheet Functions | |||
Worksheet Protection | Excel Discussion (Misc queries) | |||
How can I password protect a worksheet from being deleted | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Password Protect Cells | Excel Discussion (Misc queries) |