spot_img

How To Enable Macros In Excel VBA

In this lesson you will learn how to enable macros in Excel 2010. This is useful trick because in Excel it is not so easy to find this option.What to do when somebody disabled macros in your spreadsheet?Go to Ribbon. Click File > Options.

Excel Ribbon File Options

Click Trust Center > Trust Center Settings.

Trust Center Options

From the left bar select Macro Settings.

Tick 4th option: Enable all macros. Actually this is not so dangerous… when you use spreadsheets from there source you trust.

Enable Macros Excel 2010

 

Template

You can download the Template here – Download
Further reading: 
Basic concepts 
Getting started with Excel
Cell References
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell

RELATED ARTICLESMORE FROM AUTHOR