98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel+and+powerpoint+courses+uk - Macros
excel+and+powerpoint+courses+uk - Macros
Resolved · Low Priority · Version Standard
Angelie has attended:
Excel Advanced course
Excel Intermediate course
Macros
How can I open a macro file
RE: Macros
Hi Angelie
To open a macro file, go to Tools menu, Macro, Macros.
Highlight macro, and click on Edit to open up the VBA window. This will enable you to edit the macro.
However to edit to an advanced level you will require knowledge of VBA programming language.
Please visit our website for our VBA courses if this is a requirement.
Hope this helps
Sandy
RE: Macros
Dear Angelie
Thank you for attending Excel Training.
I am not sure what the question is exactly gearing towards.
If you are asking how we open a file that has got Macro in it then you simply open it as any file and depending on the security it might give you a warning that a macro is attached to the file do you want to enable it or disable it.
NOTE: If the security settings in Excel are set to high then it will not allow you to open the file with macros . In that case you have to go to tools> Macros> Security and change the settings to medium. Try not to set it to Low as this can result in opening any file that contains a macro.
It is important to understand that macros are one of the ways hackers send viruses so if you don
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Saving your Excel Spreadsheet as a CSV FileIn situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps. |