Getting a Macro to work in another workbook

[alsu53]

Hi Excel experts. Your help please - with simple non technical answers.

I'm creating macros and saving them to PERSONAL.xls.

Now some of the macros will work on any workbook, but some won't.

When I look at those macros (in edit) which don't work, they are looking for worksheets named as per the worksheet on which I created them.

So, why do some of my macros run on any worksheet/ book and some not.

I can't see what I'm doing differently

Help!!!

 

[jbeaucaire]

Macros destined for the PERSONAL.XLS must be edited to refer to either:

1) The Activesheet, thus all commands apply to the active sheet at time of execution
2) A sheet the macro finds and stores in a worksheet variable, then uses the worksheet variable to continue to apply to that sheet.


It sounds like you already see the problem. Try to associate all commads to the "activesheet", or post the code here and we'll offer specific suggestions.