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

macros

ResolvedVersion 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:

Navigate with keyboard without losing your active cell

If you like using your keyboard to scroll through your excel document, but want to keep your active cell the same, use the scroll lock, and then use your arrow keys to navigate around the document.

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.23 secs.