SOLVED: Run macro all all open workbooks with one exception

[RobertHT]

Hi I'm still pretty new to VBA,

I would like to run a macro on all open workbooks with the exception of one (which is the workbook i have my macros stored on). Could anyone help thanks

[RobertHT]

sorted...

[Kenneth Hobs]

What does sorted mean?

Depends on what you macro will do. Maybe something like:
[VBA]Sub RunMyMac()
Dim wb As Workbook
For Each wb In Workbooks
If wb.Name <> ThisWorkbook.Name Then
wb.Activate
MyMac
End If
Next wb
End Sub
[/VBA]

[RobertHT]

hey ken,

thanks for that. How do i change the thread to solved?

[GTO]

Greetings Robert,

Above your first post, click the button "Thread Tools" and Marked Solve is available to the original poster.

Have a great day,

Mark