macros
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Macros

resolvedResolved · Low Priority · Version 2003

replyReply Fri 13 Nov 2009, 16:01Delegate Andrea said...

Andrea has attended:
Excel Advanced course

Macros

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

For upcoming training course dates see: Pricing & availability

replyReply Sun 15 Nov 2009, 20:38Trainer Simon said...

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.

 

Please browse our web site to find out more about
excel software training and other Microsoft training courses.

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard