ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   normal.dot (https://www.excelbanter.com/new-users-excel/99114-normal-dot.html)

Ron

normal.dot
 
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



Special-K

normal.dot
 

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


--
Special-K
------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=561130


Bob Phillips

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

--
HTH

Bob Phillips

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

"Ron" wrote in message
...
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





Gord Dibben

normal.dot
 
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

On Thu, 13 Jul 2006 16:30:22 +0100, "Ron" wrote:

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



Bob Phillips

normal.dot
 
Typo

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

--
HTH

Bob Phillips

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

"Bob Phillips" wrote in message
...
See http://www.contextures.com/xlfaqMac.html£NoMacros

--
HTH

Bob Phillips

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

"Ron" wrote in message
...
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








All times are GMT +1. The time now is 12:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com