| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Don't unhide my worksheets
In your active sheet,
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Sheet2.Visible = xlSheetVisible Then Sheet2.Visible = xlSheetHidden End If End Sub Dean wrote: I wrote a macro that hides worksheets under certain conditions. Is there a way so that users can't simply unhide those sheets, perhaps via some sort of password they wouldn't know? Does the workBOOK need to be protected to accomplish this? If so, what are the other adverse implications of protecting a workbook? I don't want a cure worse than the disease. Thanks! Dean ------=_NextPart_000_0011_01C6F3AE.02124A50 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Google-AttachSize: 892 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" <HTML<HEAD <META http-equiv=Content-Type content="text/html; charset=iso-8859-1" <META content="MSHTML 6.00.2900.2963" name=GENERATOR <STYLE</STYLE </HEAD <BODY bgColor=#ffffff <DIV<FONT face=Arial size=2I wrote a macro that hides worksheets under certain conditions. Is there a way so that users can't simply unhide those sheets, perhaps via some sort of password they wouldn't know? Does the workBOOK need to be protected to accomplish this? If so, what are the other adverse implications of protecting a workbook? I don't want a cure worse than the disease.</FONT</DIV <DIV<FONT face=Arial size=2</FONT </DIV <DIV<FONT face=Arial size=2Thanks!</FONT</DIV <DIV<FONT face=Arial size=2Dean</FONT</DIV</BODY</HTML ------=_NextPart_000_0011_01C6F3AE.02124A50-- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unhide Worksheets | Excel Discussion (Misc queries) | |||
| Unhide Worksheets | Excel Discussion (Misc queries) | |||
| Unhide Worksheets | Excel Discussion (Misc queries) | |||
| unhide several worksheets | Excel Discussion (Misc queries) | |||
| Hide and unhide worksheets | Excel Programming | |||
Threaded Mode
