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

Andrea has attended:
Excel Advanced course

Macros

How do I share my macro with people using other PC's in my department?

RE: macros

Hi Andrea,

Thank you for your question.

Record the macro in a workbook and save the macro as an add-in in the Save As dialogue box.

Place the file on a shared network and then your colleagues can import the Add-in via Tools, Add-Ins and then Browse.

I hope this answers your question.

Regards

Simon

Sun 22 Nov 2009: Automatically marked as resolved.


 

Excel tip:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

View all Excel hints and tips


Server loaded in 0.08 secs.