visible sheets
I have some sheets that are invisible.
I need a code that makes alla sheets in a workbook visible. |
visible sheets
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 |
visible sheets
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. |
visible sheets
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. |
All times are GMT +1. The time now is 01:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com