
How to open developer tab excel 2007 windows#
Click "OK" on all open windows when done. Under "Macro Settings", select "Enable all macros". This will open up "Trust Center" window and on the left hand side, click "Macro Settings". At the right side of the page, click "Trust Center Settings". This will open up "Excel Options" window and on the left hand side, click "Trust Center". If you have Microsoft Excel 2010, open up Excel, select the "File" tab and on the left hand side, click "Options".In the Macro Settings, select "Enable all macros".
How to open developer tab excel 2007 code#
Select the Developer tab and in the Code box select Macro Security. The Developer tab should now show up at the top of Excel. In Excel Options, select Popular in the left-hand column and on the right under Top options for working with Excel, check the box that says "Show the Developer Tab in Ribbon". If you do not have the Developer tab, you can add one by selecting the Office button at the top left corner, scrolling down and selecting the Excel Options button.



On the Security Level tab, select the Medium or Low setting and on the Trusted Sources tab, select Trust All. If you have Microsoft Excel 2003, you can enable Macro by opening up Excel and going to Tools menu.Open Microsoft Excel and activate Macros.
