View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] troysteadman@yahoo.co.uk is offline
external usenet poster
 
Posts: 7
Default Hiding "modules"

Hi All

Yes I know you don't have modules any more...

For Each wbk in Application.Workbooks
For each sht in wbk.Sheets
Select Case sht.Name
Case "MySheet"
sht.Visible=False
End Select
Next
Next

....cycles through every sheet in every Workbook that is open, and
hides any that are called "MySheet". I want toi do the same with VB
Modules but can't seem to find the object - formerly known as a
"Module".

Help!