Removing Macro Screen At Startup

E

Eric Fehlhaber

I have a .xls file that for some reason when it is opened asks if I want to enable or disable macros. I don't have any macro's in this document and if I do I don't want them in there. Can someone please give me instuctions on how to prevent excel from asking if I want to enable or disable macros? Thanks

Eric
 
K

kkknie

You can turn security off, but then you will not have any security i
the case that someone sends you an excel file with an Workbook_Ope
macro with a virus.

Do this by going to Tools | Macros | Security and set it to Low.

I would be more concerned that there is a macro somewhere that yo
don't know about...
 
B

Bob Flanagan

Eric, I have a product at my site that can remove such phantom macros. It
is the found at http://www.add-ins.com/macroremover.htm

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

Eric Fehlhaber said:
I have a .xls file that for some reason when it is opened asks if I want
Click to expand...
to enable or disable macros. I don't have any macro's in this document and
if I do I don't want them in there. Can someone please give me instuctions
on how to prevent excel from asking if I want to enable or disable macros?
Thanks!
 
P

Peo Sjoblom

Could you please refrain from spamming!

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
A

Anders S

Eric,

Take a look here for some good instructions:

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

HTH
Anders Silven

Eric Fehlhaber said:
I have a .xls file that for some reason when it is opened asks if I want to
Click to expand...
enable or disable macros. I don't have any macro's in this document and if I do
I don't want them in there. Can someone please give me instuctions on how to
prevent excel from asking if I want to enable or disable macros? Thanks!
 
Top