My code from the Macro Recorder keeps giving me errors.

[andrewb90]

I thought this code seemed pretty simple - All I need to do is unhide a sheet. From the Macro recorder I got:

    Sheets("Archives").Select
    ActiveWindow.SelectedSheets.Visible = True

When I run my Macro I get Run-Time Error '1004'
select method of worksheet class failed

 

[SteveO59L]

Does the sheet "Archives" exist?

 

[andrewb90]

it does. The code came directly from the recorder as I unhid it.

 

[CharlesChuckieCharles]

Try
Sheets("Archives").Visible = True

you can't Select a hidden sheet


this toggles the sheet hidden or not hidden

Sheets("Archives").Visible = Not Sheets("Archives").Visible

 

[andrewb90]

Sweet! Thank you!