macros

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 2003

Kathy has attended:
Excel Advanced course

Macros

How do I make a macro non-workbook specific, so that it works in any Excel file?

Edited on Wed 16 Apr 2008, 08:30

RE: Macros

Hi Kathy, Thank you for your post, welcome to the forum, in answer to your question, when you are creating your macro, in the first dialog box after choosing menu command Tools>Macro>Record New Macro, in the Store macro in text box, use the drop down arrow choices and select Personal Macro Workbook. Record your macro in the normal way. Your macro will now be available to you whenever you open that PC's version of Excel.
To delete this macro you cannot use the normal method of deleting it from the Macro dialog box; The macro has been saved in a special hidden workbook, so you must first Hide the current workbook, Window>Hide, then immediatly go to Window>Unhide, you will see the Personal Macro Workbook displayed in the choices, open it and delete the Macro/s as per normal, Save the Personal Macro Workbook, and then Hide it as above, then Unhide your original Workbook, the macro will not be shown or operate. I hope that has helped, best regards Pete.

 

Training courses

 

Training information:

See also:

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:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips


Server loaded in 0.08 secs.