Macro Warning
I've been working on a payroll spreadsheet, suddenly when I open it, I get
the macro warning, but I haven't created any macros. Help? |
Macro Warning
Are you using anything from the control toolbox? regardless, open the
workbook, press alt + F11, in the project pane to the left check to see if you have any modules, if so right click it/them and select remove module, answer no when prompted, if there are no modules double click each sheet module and ThisWorkbook, delete whatever code might be in those, press alt + Q to close the VBE and then save the workbook. HTH -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Ted Dawson" wrote in message ... I've been working on a payroll spreadsheet, suddenly when I open it, I get the macro warning, but I haven't created any macros. Help? |
Macro Warning
Maybe somebody put in some code or a empty module, have a look here for
details on where to look and get remove them http://www.contextures.com/xlfaqMac.html#NoMacros -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Ted Dawson" wrote in message ... I've been working on a payroll spreadsheet, suddenly when I open it, I get the macro warning, but I haven't created any macros. Help? |
Macro Warning
Thanks, exactly right, and empty module. A round to the house from me.
Ted "Paul B" wrote in message ... Maybe somebody put in some code or a empty module, have a look here for details on where to look and get remove them http://www.contextures.com/xlfaqMac.html#NoMacros -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Ted Dawson" wrote in message ... I've been working on a payroll spreadsheet, suddenly when I open it, I get the macro warning, but I haven't created any macros. Help? |
All times are GMT +1. The time now is 07:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com