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?
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

quot;Ted Dawsonquot; gt; wrote in message
...
gt; I've been working on a payroll spreadsheet, suddenly when I open it, I get
gt; the macro warning, but I haven't created any macros. Help?
gt;Maybe somebody put in some code or a empty module, have a look here for
details on where to look and get remove them
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 amp; 2003

quot;Ted Dawsonquot; gt; wrote in message
...
gt; I've been working on a payroll spreadsheet, suddenly when I open it, I get
gt; the macro warning, but I haven't created any macros. Help?
gt;
gt;
Thanks, exactly right, and empty module. A round to the house from me.

Ted

quot;Paul Bquot; gt; wrote in message
...
gt; Maybe somebody put in some code or a empty module, have a look here for
gt; details on where to look and get remove them
gt; www.contextures.com/xlfaqMac.html#NoMacros
gt;
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Ted Dawsonquot; gt; wrote in message
gt; ...
gt;gt; I've been working on a payroll spreadsheet, suddenly when I open it, I
gt;gt; get
gt;gt; the macro warning, but I haven't created any macros. Help?
gt;gt;
gt;gt;
gt;
gt;
文章標籤
全站熱搜
創作者介紹