Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
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.
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
1 Answer
- garbo7441Lv 71 decade agoFavorite 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.
