macros

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

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

Macros

resolvedResolved · Low Priority · Version Standard

Fern has attended:
Excel Advanced course
Excel Advanced course

Macros

how do you edit a macro

RE: macros

Dear Fern

Thank you for attending the Excel Advanced Course. I hope you enjoyed it.

You can access the Visual Basic Editor to make necessary changes for your current macro. Please bear in mind that this window expects you to have knowledge of VBA (Visual basic For Application) which is a programming language. You can do simple changes such as changing the name, changing the margins, or calculations in a formula quite simply but if you want to do more complicated editing then I would suggest you to attend our two day course to get in-depth knowledge and understanding of creating/editing macros.

Below is an example how you

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips


Server loaded in 0.08 secs.