Stu,

That sounds as if you have got the name of the worksheet wrong. As I
suggested, it would be of the format

Call Worksheets("Sheet1").macro1

and make sure it is not private. But again I suggest that you put it in a
normal code module, which you can create from the Insert menu.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Stu" wrote in message
...
When I try to run the macro which opens macros from other sheets i get
an error message saying:

Microsoft Visual Basic (In top bar)

Subscript out of range

any ideas as to why this happens?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/