personalxslb

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Personal.XSLB

Personal.XSLB

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Reset Excel toolbars to default settings

If 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.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips


Server loaded in 0.08 secs.