How do I stop Macros from opening with every excel spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 Insert>Module.

Save the workbook when complete.

To stop Personal.xls from opening, take it out of your XLSTART folder.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel 2007 macro question 1
Excell 2000 macro will not open file! 1
Repetitive macros 1
How do you eliminate macro warnings if you deleted macros 2
how do i set up opening a file from a cell in excel spreadsheet 1
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
Macros in Excel (Office 2007) 3
How do I write to a closed work book as a "register" 1

Back
Top