Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Noob Question 3
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..... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Noob Question 3
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. "O...." wrote: 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..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Noob Question 2 | Excel Programming | |||
Noob Question | Excel Programming | |||
Noob Question Probably! :S | Excel Programming | |||
Noob question | Excel Worksheet Functions | |||
Noob question | New Users to Excel |