Cannot set visible property to the worksheet class

[jarlej]

Hi,
Could anybody point me to a solution?

I get run-time error '1004' at the last line: Cannot set visible property to the worksheet class

Sub kopierLoggPedTiltak()
    Sheets("LoggPedTiltak").Copy After:=Sheets(1)
    ActiveSheet.Visible = 1
    Sheets("Innhold").Visible = 0
End Sub

Thanks!

(I used to be a member like 10+ years ago, but couldn't find my old login )

 

[davesexcel]

Here is a topic on that

Just a note, the activesheet would be visible, you would not have to make it visible.

unable to set the visible property of the worksheet class

Various sheets are hidden and made visible through macros. Every once in a while sheets will be hidden and i cannot get them unhidden. When I right click on a sheet name the hide, unhide options are grayed out. I have tried Sub UnHideSheets() Dim ws As Worksheet For Each ws In...

www.mrexcel.com

 

[jarlej]

Hi, and thanks for the tip. I´ve already seen that topic, but I couldn't find a solution in that thread.