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

can you share macros

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Can you share Macros on Excel with other people? To be used acro

Can you share Macros on Excel with other people? To be used acro

ResolvedVersion 365

Jonathan has attended:
Excel Advanced course
Excel Intermediate course
UoL 365 Digital Champions Training course

Can you share Macros on Excel with other people? To be used acro

Hi. In the nature of my work I am part of a team that receives a lot of the same data and has to conduct the same functions each time. Whilst your training has helpfully taught me that Macros will help make this process efficient, I was wondering is there a way to share MY created Macro code/settings with other people so that they can implement it on their own Excel workbooks and not just across my own?

RE: Can you share Macros on Excel with other people? To be used

Hi Jonathan,

Thank you for the forum question.

Yes that is simple. The Visual Basic editor is just a text editor. Copy the macro and send the code to the person.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 2 Aug 2023: Automatically marked as resolved.

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

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