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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Check Box Diasabel/Enable RUN MACRO

Status
Not open for further replies.

amecari

Technical User
Mar 21, 2001
29
BR
I need help.
I want to run a macro in excel, I"m using auto_open, but when I open workbook, excel ask me if I want disabel/ enbale run macro.
Can I write code to elminate this check box???


Thanks a lot.


Iracema
 
Iracema,

In a word, no. This is a security feature and cannot be accessed via VBA (macro) code, which would defeat its purpose. It is intended to stop malicious macros from running. This can be disabled through Excel's user interface, if so desired.

Regards,
M. Smith
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top