Macro page in Excel causing two pages to open how do I?

I wrote several macros for a report that I created. They are simple macros and I saved them to a "personal" macro page. When I open excel, this personal page comes up every time, is there anyway to stop that page from coming up but still use the macros?

Also, at some point I had put a report on that personal page and though I named it something else, every time I open Excel, that page now opens too, it's enough to drive a person batty!!!!

Thanks for your help in advance.

2009-03-12T15:19:41Z

I guess I don't know the difference between sheet and workbook? When I open excel two files open, one is called personal.xls...it's a blank page but it has to be open for my macros to work, and the other one I have named 1 just because it's nothing, it opens as if it is my personal workbook. I don't know how to copy code from macros, if you give me a step by step, I will sure try. You can email me at jmarinerklein@hotmail.com

garbo74412009-03-12T21:18:21Z

Favorite Answer

The process you describe is used by folks that need to use the same macro(s) in multiple workbooks. This precludes the need to write the same macro in multiple workbooks. It reduces overhead and time spent writing or copying and pasting macros.

You create a new workbook to hold all your macros, name it 'Personal.xls' and save it to your XLStart file. This file, for Excel 2003, is located in C:\Program Files\MicrosoftOffice\ Office11\XLStart

Then, whenever Excel or an Excel spreadsheet is opened, Personal.xls is automatically opened also. All macros contained in Personal.xls are then available to all open workbooks.

If you want to get rid of Personal.xls, you just have to delete it from the XLStart folder. If you want to move the macros from Personal.xls to your particular spreadsheet before deleting it from the XLStart folder, you will need to access the VBE.

Open your workbook and then press ALT + F11.

In the VBA Projects (upper left) you will see both spreadsheets listed with expandable menus. Locate the Personal.xls and double click on the first module listed. If any macros appear to the right, copy and paste them into a module listed under your spreadsheet. If no modules are listed for your spreadsheet, Insert > Module then paste the macros in.

Repeat the process for each module listed under Personal.xls. Then delete Personal.xls from the XLStart folder.

00

Related Questions

How do i keep excel from opening book1 and open two seperate pages?every time i open internet explorer it opens page after page what would cause this?A student opens a mathmatics book to two facing pages. The product of the page numbers is 1640.?Good afternoon class....please open up your textbooks to page 39, we will be dissecting Bohemian Rhapsody!!!?how to have two pages open at same time?

Trending Questions

Covid 19 face mask?9 answersWhich software is best for editing? ?21 answersDid you like being on lockdown during covid?17 answersWhich one is better? Office 2019 or Office 365?13 answersI saw Windows Vista on computer behind desk at  cinema?7 answers