macros

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Macros

resolvedResolved · Low Priority · Version 2013

Irit has attended:
Excel Advanced course

Macros

How do I change a macro that I save as worksheet macro to a personal macro

RE: Macros

Hi Irit,

Thank you for the forum question.

To get access to the personal macro workbook you will have to record a macro and store it in the Personal Macro workbook. Then you have to open the visual basic editor (Alt F11). You will now be able to access the module in the personal macro workbook.

Copy macro and paste it in the personal macro workbook module.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best 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

Thu 20 Jul 2017: Automatically marked as resolved.


 

Excel tip:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

View all Excel hints and tips


Server loaded in 0.06 secs.