Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Leona Wright on Dec 07 In MS Office Category.

Using code on multiple worksheets in a workbook

Question Answered By: Chione Massri on Dec 07

This works(tested):

Sub hide()
Dim ws
Dim rw
For Each ws In ActiveWorkbook.Sheets
For Each rw In ws.UsedRange.Rows
If rw.Cells(3) = 0 And rw.Cells(5) = 0 _
And rw.Cells(6) = 0 Then rw.Hidden = True
Next rw
Next ws
End Sub

This Question has 2 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Using code on multiple worksheets in a workbook Or get search suggestion and latest updates.

Related Topics:

Prob running workbook activate code when workbook is opened by anot
Simplest way to check for a blank worksheet in an excel workbook
List of objects on a worksheet within a workbook
How to insert some worksheets to a closed workbook
Activate a worksheet or workbook with a variable name
Updating worksheets to my Summary in workbook
Select a value from a specified worksheet in a closed workbook
List from other worksheet or workbook?
referencing another worksheet in different workbook?
Workbook and Worksheet manipulation
Question when using Multiple Workbooks
Need help coping images (gif pictures) from worksheet to worksheet
Need help coping images (gif pictures) from worksheet to worksheet
Excel data transfer automatically from master worksheet to other worksheets
Finding and retrieving data on multiple worksheets
Next Workbook or Previous Workbook
Making a Workbook as an Active Workbook without opening it
Run Macor in a closed workbook and refer to the closed workbook
Change Workbook's Name
Disable Workbook event procedure with code?

Tagged:using code on multiple worksheets in workbook

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us