normal.dot

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ron - 13 Jul 2006 16:30 GMT

Hi is there an equivalent to normal.dot in excel. Everytime I open a blank
excel spreadsheet I get a macro warning but I cannot find any macros.

Office/Excel 2003 and windows XP pro with SP2
Thanks Ron

Reply to this Message

Special-K - 13 Jul 2006 17:06 GMT

Risky but you could try Tools/Macro/Security and setting it to Low..

--
Special-

Reply to this Message

Bob Phillips - 13 Jul 2006 17:46 GMT

See http://www.contextures.com/xlfaqMac.html£NoMacros

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi is there an equivalent to normal.dot in excel. Everytime I open a blank
> excel spreadsheet I get a macro warning but I cannot find any macros.
>
> Office/Excel 2003 and windows XP pro with SP2
> Thanks Ron

Reply to this Message

Bob Phillips - 13 Jul 2006 18:48 GMT

Typo

See http://www.contextures.com/xlfaqMac.html#NoMacros

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> See http://www.contextures.com/xlfaqMac.html£NoMacros
>
[quoted text clipped - 3 lines]
> > Office/Excel 2003 and windows XP pro with SP2
> > Thanks Ron

Reply to this Message

Gord Dibben - 13 Jul 2006 18:29 GMT

Ron

There is no Normal.dot for Excel.

Sounds like your default new workbook is based on a Template that once held
macros but has had them deleted and the empty module(s) left behind.

To deal with this, see Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros

Find out from where the New blank workbook is opening from and either delete
that Template of modify.

I would be tempted to just delete and let Excel's default workbook take over.

Gord Dibben MS Excel MVP

>Hi is there an equivalent to normal.dot in excel. Everytime I open a blank
>excel spreadsheet I get a macro warning but I cannot find any macros.
>
>Office/Excel 2003 and windows XP pro with SP2
>Thanks Ron

Reply to this Message