Written by:

Written by:

Thomas Szigeti

How to enable macros In Excel?

To be able to use the fancy macro capability of Excel, we have to enable it.

It is not difficult to turn this on, but the settings are a little bit buried in the option menu.

So let’s get to it!

VBA macros are programme snippets, which can do magical things if you use it right.
But it can also be very dangerous like any piece of code that you are copying to your workbook. It might carry some commands that can be harmful or dangerous to your system.

For this reason Excel by default disables macros to be run on start-up.
So if you want to use macros in your book you have to enable the macros.

This is a good thing right?

Well, yes and no.

Yes because it’s saving your system from complete meltdown in case of some malicious code would just run on your system.

No because it’s super inconvenient to always enable the macros that you wish to run.

My suggestion is, if you mainly working with your own macros, -mean you write and execute the code then, by all means you can enable macros to run.

Because you are the guarantee that no malicious code gets to run.

The risk is: that one day someone might send you a macro enabled workbook which you will open without any warning.

Anyhow in the next few videos I will show you how to enable macros in Excel.

As you can see there is 4 options available in the options window: 

  • Disable all macros without notification
  • Disable all macros with notification
  • Disable all macros except digitally signed macros
  • Enable all macros (not recommended, potentially dangerous code can run)

Disable all macros without notification

 

Here you can disable all macros without notification.
This means that you won be bothered by a notification and no mark your scanner on in your workbook.

Disable all macros with notification

 

Macros are disabled but a security prompt will pop up, if you have macros in the workbook.
This allows you to evaluate enabling macros on a case-by-case basis.

Disable all macros except digitally signed macros 

 

It’s almost the same as the previous version, if there much was present in the verbal prompt will pop up allow you to enable or disable the macro. Except if the macro is digitally signed by a trusted publisher.

Enable all macros

This is a dangerous way to trust ALL macros with no notification. This settings will enable ALL macros to run without any prompt. 

Why this is dangerous?  – Dangerous and harmful macros can run on your machine without your knowledge. 

Come and visit us.

Come and visit excelangel on Facebook to find and join the growing community of true office workers.

Oh, I almost forgot.
Drop us a like while you there…

[et_pb_ccfcm_facebook_comments_module ccfcm_app_id=”339898187197719″ _builder_version=”4.6.1″ _module_preset=”default”][/et_pb_ccfcm_facebook_comments_module]