Call macro after "macros are enabled"
in [Programming]
|
Prev: How do I make excel say a phrase when hitting a certain goal in a
Next: reference excel interop assemblies
From: fish on 7 Feb 2010 17:42 Hi there, I am quite a noob in programing VBA so this question might seem really trivial to some of you, but unfortunalty it is not for me ;) I want to start a macro, after the user has accepted the default security message, excel is showing. Disabling this message is not possible, because the sheet has to work on "any" computer in the company. So, how is it possible to start a macro, right after the user has enabled them? Thanks in advance and sorry for my bad english. Great regards, fish
From: Roger Govier on 8 Feb 2010 04:03
Hi Either place the code in ThisWorkbook as a Workbook_Open event Private Sub Workbook_Open() .... your code End Sub or in a regular modular with a name of Sub Auto_Open() .. your code End sub -- Regards Roger Govier "fish" <fish(a)discussions.microsoft.com> wrote in message news:B3457F76-E5FF-4C41-96CF-476AB59AAF56(a)microsoft.com... > Hi there, > > I am quite a noob in programing VBA so this question might seem really > trivial to some of you, but unfortunalty it is not for me ;) > > I want to start a macro, after the user has accepted the default security > message, excel is showing. Disabling this message is not possible, because > the sheet has to work on "any" computer in the company. > > So, how is it possible to start a macro, right after the user has enabled > them? > > Thanks in advance and sorry for my bad english. > > Great regards, > fish > > __________ Information from ESET Smart Security, version of virus > signature database 4846 (20100208) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > __________ Information from ESET Smart Security, version of virus signature database 4846 (20100208) __________ The message was checked by ESET Smart Security. http://www.eset.com |