![how to enable macro in excel 2010 how to enable macro in excel 2010](https://i.pinimg.com/originals/89/23/54/8923540e977e861b8b375b0be1158cdb.jpg)
#HOW TO ENABLE MACRO IN EXCEL 2010 HOW TO#
Everything should now work, but we still need to secure our macro code so that a user can't break the functionality that we have just created and see the worksheets without having macros enabled - at this point, even just a semi-advanced user, or someone who did a five minute online search, could figure out how to show all of the hidden worksheets without having macros enabled.You can have as many of these as you need simply copy/paste the line of code for the data worksheet below the other one and change "Data" to the name of the other worksheet. For the "Data" worksheet note that this will just be whatever worksheet you want the user to see once they have enabled macros. Change Reminder to the name of the worksheet that will remind users to enable macros.Ĭhange Data to the name of the worksheet that will contain the data. If the user does not have macros turned-on, they will only ever see the Reminder worksheet and nothing else. This code says that when the user opens the workbook, the Data worksheet will appear and the Reminder worksheet will disappear but, when the user closes the workbook, the Reminder sheet will appear and the Data sheet will disappear and then the file will be saved, in order to save the hiding of the Data worksheet. Private Sub Workbook_BeforeClose(Cancel As Boolean) Sheets("Reminder").Visible = xlVeryHidden 'worksheet that shows reminder to enable macro 'worksheets to show when macro is enabled In the window that opens, copy and paste this code:.
![how to enable macro in excel 2010 how to enable macro in excel 2010](https://www.learningcomputer.com/blog/wp-content/uploads/2015/11/Excel-2010-Excel-Options.jpg)
![how to enable macro in excel 2010 how to enable macro in excel 2010](https://i.stack.imgur.com/ldRuH.png)
There are a few steps involved in making this work securely and I will go through each of them below. This is very important when macros make-up a critical part of the workbook and not having them can stop the workbook from performing correctly or allow users to mess-up or corrupt the data and functionality of the spreadsheet. Tutorial showing you how to make a user enable macros in a workbook in order to view the workbook.