| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to open two macro excel files for macros to work
Hi folks. I put together 13 macros in one excel file ("file a"). Then
I renamed the file to "file b". Now, when I go to run the macros, it requires that both files "a" and "b" be open. (I changed both files in the meantime.) Any ideas as how I could get away with just having one file open? Thanks for any help. Nigel. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to open two macro excel files for macros to work
Try putting/recording the macro's in the 'personal macro workbook' instead of
'this workbook'. They then should be available in any open workbook "nigelbarham" wrote: Hi folks. I put together 13 macros in one excel file ("file a"). Then I renamed the file to "file b". Now, when I go to run the macros, it requires that both files "a" and "b" be open. (I changed both files in the meantime.) Any ideas as how I could get away with just having one file open? Thanks for any help. Nigel. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to open two macro excel files for macros to work
Mark: thanks so much for this tip. Your suggestion put me on the right
path to the solution. Fixed! Nigel. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Open Excel Files with Macros | Excel Discussion (Misc queries) | |||
| How open old .wks files without software? Excel viewer no work | Setting up and Configuration of Excel | |||
| Macros to Open & Update Files | Excel Programming | |||
| Multiple persional.xls files making macros NOT work! | Excel Programming | |||
| Macro Size Limit / open macros with macros? | Excel Programming | |||
Hybrid Mode
