Macros

Hi David,

Thank you for the forum question.

You will need to write a VBA code to do what you want.

In the visual basic editor in Excel in the module where your macros are stored, click under the last macro (under the line End Sub) and type

Sub RunAll and press Enter. This will give you:

Sub RunAll()

End Sub

Between RunAll() an the line End Sub type the name of the macros in the order you want to execute them. If you for example have macros with the name ChangeHeader, FormatText, AddColumns, the code should look like this


Sub RunAll()
ChangeHeader
FormatText
AddColumns

End Sub

Then by running the RunAll macro you will run all the macros listed inside the RunAll macro.

I hope this makes sense.




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