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--
|