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

excel+and+powerpoint+courses+uk - macros

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+and+powerpoint+courses+uk - Macros

excel+and+powerpoint+courses+uk - Macros

ResolvedVersion 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:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.