excel+and+powerpoint+courses+uk - 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 » excel+and+powerpoint+courses+uk - Macros

excel+and+powerpoint+courses+uk - Macros

resolvedResolved · 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


 

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips


Server loaded in 0.1 secs.