Stu,
So call like
Call Worksheets("Sheet1").macro1
Call Worksheets("Sheet2").macro2
But make sure they are not private.
Also, why have you put macros in a sheet module? If you want to call them
from elsewhere it is easier to put them in a normal code module
(InsertModule).
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Stu" wrote in message
...
The macros are in:
VBA project (Filename.xls)
Microsoft excel objects
Sheet 1
Sheet 2 (Here is where the macros are(the sheets))
Etc...
Thanks
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/