Noob Question 3

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook called Vacation Accrued within that workbook I have
Wooksheets for John Doe, Jane Doe, Joe Smith, Suzzie Jones, etc I Want to
execute that code when the Wookbook is open for all Worksheets (John Doe,
Jane Doe, Suzzie Jones and So On.....
 
This is the basic idea.

Sub myWkbShts()
Dim sh As Worksheet
For Each sh In Workbooks("Vacation Accrued").Sheets
myMacro
Next
End Sub

Sub myMacro()
'Do stuff with John, Jane, Suzy, etc.
End Sub

You use one macro to call each sheet in the workbook and for each sheet you
run the macro that does something to the sheet. It will toggle back and
forth between the two macros until each sheet in the target workbook has been
worked by the macro that makes adjustments to the sheets.
 
Back
Top