98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Personal.XSLB
Personal.XSLB
Resolved · High Priority · Version 2007
Sasha has attended:
Excel Advanced course
Personal.XSLB
I created a Macro in personal workbook but got frustrated when it opened as a seperate workbook everytime I opened anything in Excel so tried to delete it.
Now I appear to have no macros, but if I open excel automatically a workbook opens called Personal.XSLB too. even if I open an existing file from my folders it will also open the Personal.XSLB too.
How can I get rid of this workbook and stop it from opening all the time?
Also if I re-create the macro and I want it to appear as an icon in every workbookk but not run unless I click it, do I save it as 'this workbook', 'new workbook' or personal?
Many thanks
RE: Personal.XSLB
Hi Sasha
Thanks for the question
The personal macro workbook stores your macros in a central place and allows you to run them in any open workbook. Thus, this is the place that you should save macros when you want to use them on more than one workbook.
As to the personal workbook opening, this is what it is meant to do. This makes the macros available. However, it should be hidden so you cannot see it.
The Personal Macro workbook is contained in a folder called xlStart. You will need to search for it as its position varies. Once you have found it, open the folder and right click on the personal macro workbook file and select properties.
Tick the hidden check box.
That should solve the problem
Regards
Stephen
Wed 20 Jan 2010: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Reset Excel toolbars to default settingsIf you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults. |