I have some sheets that are invisible.
I need a code that makes alla sheets in a workbook visible.

Could you do a for each loop that has a sheet.visible inside?? Tha
would work.

--
ehnt
-----------------------------------------------------------------------
ehntd's Profile: http://www.excelforum.com/member.php...fo&userid=1586
View this thread: http://www.excelforum.com/showthread.php?threadid=27767

Hi
try

sub foo()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.visible=true
next
end sub

"Bombermanx" wrote:

I have some sheets that are invisible.
I need a code that makes alla sheets in a workbook visible.

Yes, it workt. Thank you wery much!

"Frank Kabel" skrev:

Hi
try

sub foo()
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.visible=true
next
end sub

"Bombermanx" wrote:

I have some sheets that are invisible.
I need a code that makes alla sheets in a workbook visible.