Hi
you probably hardcoded the activesheet in your 'othermacro'. You have
to pass the worksheet object to your other macro and use this as
reference for your macro

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
I have the following macro than contains another macro:

Sub MonthList()

Dim wks As Worksheet

For Each wks In Worksheets
OtherMacro
Next wks

End Sub

However, when i run it, OtherMacro (a list of months) only
get executed in the active worksheet. What am i doing
wrong?

regards