Monday, October 22, 2012

How to Find Hidden Macros in an Excel Spreadsheet


Finding Macros with the Macro Tools in Excel
1. Open Excel normally.
2. Click on the 'Developer Tab.'
3. Click on the button labeled 'Macros.' A dialog box will pop up. The dialog box will have all the Macros available on all open workbooks. You can select 'Macros' there and delete them.
Finding Macros with the Visual Basic Editor
4. Open Excel normally.
5. Click on the 'Developer Tab.'
6. Click on the button labeled 'Visual Basic.' The Visual Basic editor will pop up. On the left hand pane, there will be a list of every single Macro that Excel has loaded; this will include Macros that are hidden from the Macros dialog box. You can select 'Macros' here and delete them individually, or look over their code.

Blogger news