How to Stop Running on Open in Excel Spreadsheets

Disable Macros in Microsoft Excel 2007
1. Click the round Microsoft Office button at the top-left corner of the Excel screen and then select 'Excel Options' from the very bottom of the drop-down menu.
2. Select 'Trust Center' from the menu on the left-hand side of the screen and then click the 'Trust Center Settings' button.
3. Select 'Macro Settings' from the left-hand menu.
4. Select one of two options: 'Disable all macros without notification' or 'Disable all macros with notification.'
5. Click 'OK' on each of the next two screens to close the dialog boxes and save your changes.
Disable Macros in Microsoft Excel 2003 and Earlier
6. Click 'Tools' in the top menu bar, select 'Macro,' then choose 'Security' from the resulting sub-menu.
7. Select 'Medium' or 'High' from the list of options presented within the 'Security Level' tab.
8. Click 'OK' to confirm your changes.