Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

I created MAcro based fiel in excel

Status
Not open for further replies.

123121

Electrical
Joined
Jun 28, 2003
Messages
20
Location
SK
I created MAcro based fiel in excel. I saved this file as 'Excel Add-In' *.xla. When I starts excel my toolbars are visible on the toolbox. It is okey but every time I starts excel the dialog box with message "'Macros may contain viruses ...' Disable/Enable macros" is shown. Is there any way how to set anything to do not showing this dialo box?

Thanks in advance

Thanks,
Vlado
 
From memory there is a check box on this dialog box that says "Always ask before opening documents with macros?"
If you uncheck this box it shouldn't ask you again.

Cheers,

hojo
 
Hi Vlado,

What's below is related to XL2000. In other versions, slight changes may be present. Help may be useful to find the actual route.

Click Tools -> Macro -> Security.

The explanations should be satisfactory to decide on a security level.

Good luck,
Engin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top