Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I stop Macros from opening with every excel spreadsheet?
I created a macros for an excel spreadsheet but it opens up with every single
spreadsheet file that I have on my computer. How do I customize it to run with only one specific file. Thanks. |
#2
|
|||
|
|||
Alex
If you created it using the Macro Recorder it probably got saved into your Personal Macro Workbook(Personal.xls) which opens with Excel. If this is the case, open your specific workbook. Open the Visual Basic Editor by hitting ALT + F11 then CTRL + r to open Project Explorer. Select and expand the Personal.xls and double-click on Module1 to open it. Copy the code and paste it into a Module of the specific file. To create a module in your workbook, select it in VBE and InsertModule. Save the workbook when complete. To stop Personal.xls from opening, take it out of your XLSTART folder. Gord Dibben Excel MVP On Thu, 13 Jan 2005 11:27:04 -0800, AlexMilos wrote: I created a macros for an excel spreadsheet but it opens up with every single spreadsheet file that I have on my computer. How do I customize it to run with only one specific file. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I stop Excel from prompting to enable or disable macros? | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) | |||
OPENING TWO DIFFERENT EXCEL PROGRAMS | Excel Discussion (Misc queries) |