I figured it out-I had a Hyperlink attached to the button I had to remove,
then it worked. Thanks ALL!!

"Dave Peterson" wrote:

I think you're going to have to share what went wrong...

Paula wrote:

I tried this-won't work. Please treat me like the moron I am. Tell me how
to do it as if I have never done a macro before. I am missing something.
Thanks! Paula

"Jeanette" wrote:

On 15 Oct, 21:05, Paula wrote:
When in worksheet "Enrollment 1", I have a button to click. I need to assign
a macro to it (i know how to do that part) to open the next hidden worksheet
"Enrollment 2", but I cannot find the correct macro to say open or activate
"Enrollment 2". Thanks!

Hi Paula

Try this

Private Sub Reveal()
With ThisWorkbook
If Worksheets("Enrollment 2").Visible = False Then
Worksheets("Enrollment 2").Visible = True
Worksheets("Enrollment 2").Activate
End If
End With
End Sub

HTH Jeanette
.


--

Dave Peterson
.