Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can T Get Macro To Run! | New Users to Excel | |||
macro warning persists even after deleting all macros | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Macro warning (upon opening) | Excel Discussion (Misc queries) |