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

macros

ResolvedVersion 2003

Guangwen has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Macros

Where is the personal macro file stored?

RE: Macros

Hello Guy, Thank you for your post, the Personal Macro file is a worksheet which sits hidden behind the active worksheet, when you record a macro and place it on the Personal Macro worksheet it is available to all active worksheets in that Workbook. To delete a macro from the Personal Macro worksheet you must first hide the active worksheet, Window, Hide, then choose to Unhide, at which point you will be asked which worksheet to open, the active worksheet or the Macro worksheet, if you choose the Macro worksheet you can then access your macros in the normal way to edit or delete them. I hope that helps, best regards Pete

Excel tip:

Change the Default Width of All Columns in Excel 2010

If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how:

In the Cells group on the Home tab, click Format.

Hover over the section called Cell Size and a drop down list will appear, select Default Width from this list.

In the Standard Width dialog box, enter the size you want to set as the default width and click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.18 secs.