force a macro to execute

Dear experts,
is there a way I can force users to enable macros when they open a certain
workbook, or at least provoke a warning message if they disable them?
Thanks!
Best regards,
--
Valeria

Valeria,

No, there is no way to force enabling of macros. But...

Hide all the sheet in the workbook except for a single sheet with a warning
in large text that the workbook won't work unless macros are enabled, and
unhide the remaining sheets and hide the warning in an auto_open macro.

Robin Hammond
www.enhanceddatasystems.com

"Valeria" <[email protected]> wrote in message
news:[email protected]...
> Dear experts,
> is there a way I can force users to enable macros when they open a certain
> workbook, or at least provoke a warning message if they disable them?
> Thanks!
> Best regards,
> --
> Valeria

Valeria,

If you add a macro called Auto_Open, that runs when you open a workbook.

On the other point, the most common way of handling that is to have a
worksheet that puts up a message about disabling macros, and then hide all
other sheets. In your auto-open macro, hide this sheet and unhide the rest.
If they disable macros, they will see this sheet, if they don't, they will
not. Not foolproof, b ut a technique.

--
HTH

-------

Bob Phillips
"Valeria" <[email protected]> wrote in message
news:[email protected]...
> Dear experts,
> is there a way I can force users to enable macros when they open a certain
> workbook, or at least provoke a warning message if they disable them?
> Thanks!
> Best regards,
> --
> Valeria

Thanks!
It works very well...
just for curiosity: searching the posts, I have also found as an option the
digital certificate, so that basically users will be prompted only once to
enable macros written by you.
With the premises that I do not know anything about this subject, is it
something you would also suggest?
Thanks!
Valeria



"Bob Phillips" wrote:

> Valeria,
>
> If you add a macro called Auto_Open, that runs when you open a workbook.
>
> On the other point, the most common way of handling that is to have a
> worksheet that puts up a message about disabling macros, and then hide all
> other sheets. In your auto-open macro, hide this sheet and unhide the rest.
> If they disable macros, they will see this sheet, if they don't, they will
> not. Not foolproof, b ut a technique.
>
> --
> HTH
>
> -------
>
> Bob Phillips
> "Valeria" <[email protected]> wrote in message
> news:[email protected]...
> > Dear experts,
> > is there a way I can force users to enable macros when they open a certain
> > workbook, or at least provoke a warning message if they disable them?
> > Thanks!
> > Best regards,
> > --
> > Valeria
>
>
>

It's a possible solution if you think that your users will be prepared to
trust all your macros, and it can make life easier for you with your own
code. You need to look for SelfCert.exe from memory. It should be in your
office folder.

Alternatively, you can put your code in an add-in, and once the user has
elected to load the add-in the macro warning on that file won't be shown.

Robin Hammond
www.enhanceddatasystems.com


"Valeria" <[email protected]> wrote in message
news:[email protected]...
> Thanks!
> It works very well...
> just for curiosity: searching the posts, I have also found as an option
> the
> digital certificate, so that basically users will be prompted only once to
> enable macros written by you.
> With the premises that I do not know anything about this subject, is it
> something you would also suggest?
> Thanks!
> Valeria
>
>
>
> "Bob Phillips" wrote:
>
>> Valeria,
>>
>> If you add a macro called Auto_Open, that runs when you open a workbook.
>>
>> On the other point, the most common way of handling that is to have a
>> worksheet that puts up a message about disabling macros, and then hide
>> all
>> other sheets. In your auto-open macro, hide this sheet and unhide the
>> rest.
>> If they disable macros, they will see this sheet, if they don't, they
>> will
>> not. Not foolproof, b ut a technique.
>>
>> --
>> HTH
>>
>> -------
>>
>> Bob Phillips
>> "Valeria" <[email protected]> wrote in message
>> news:[email protected]...
>> > Dear experts,
>> > is there a way I can force users to enable macros when they open a
>> > certain
>> > workbook, or at least provoke a warning message if they disable them?
>> > Thanks!
>> > Best regards,
>> > --
>> > Valeria
>>
>>
>>

Hi,
I have looked for the SelfCert.exe file but I can;'t find it, neither in my
office folder, nor in my whole C drive. Is this normal? Do I need to import
it from somewhere?
Thanks!
Valeria

"Robin Hammond" wrote:

> It's a possible solution if you think that your users will be prepared to
> trust all your macros, and it can make life easier for you with your own
> code. You need to look for SelfCert.exe from memory. It should be in your
> office folder.
>
> Alternatively, you can put your code in an add-in, and once the user has
> elected to load the add-in the macro warning on that file won't be shown.
>
> Robin Hammond
> www.enhanceddatasystems.com
>
>
> "Valeria" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks!
> > It works very well...
> > just for curiosity: searching the posts, I have also found as an option
> > the
> > digital certificate, so that basically users will be prompted only once to
> > enable macros written by you.
> > With the premises that I do not know anything about this subject, is it
> > something you would also suggest?
> > Thanks!
> > Valeria
> >
> >
> >
> > "Bob Phillips" wrote:
> >
> >> Valeria,
> >>
> >> If you add a macro called Auto_Open, that runs when you open a workbook.
> >>
> >> On the other point, the most common way of handling that is to have a
> >> worksheet that puts up a message about disabling macros, and then hide
> >> all
> >> other sheets. In your auto-open macro, hide this sheet and unhide the
> >> rest.
> >> If they disable macros, they will see this sheet, if they don't, they
> >> will
> >> not. Not foolproof, b ut a technique.
> >>
> >> --
> >> HTH
> >>
> >> -------
> >>
> >> Bob Phillips
> >> "Valeria" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > Dear experts,
> >> > is there a way I can force users to enable macros when they open a
> >> > certain
> >> > workbook, or at least provoke a warning message if they disable them?
> >> > Thanks!
> >> > Best regards,
> >> > --
> >> > Valeria
> >>
> >>
> >>
>
>
>

What version of Excel. You would need xl2000 or later. Also, when
installing office, there are installation options and everything is not
installed by default.

See this for a more complete answer:

http://support.microsoft.com/default...b;en-us;217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects

--
Regards,
Tom Ogilvy


"Valeria" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I have looked for the SelfCert.exe file but I can;'t find it, neither in
my
> office folder, nor in my whole C drive. Is this normal? Do I need to
import
> it from somewhere?
> Thanks!
> Valeria
>
> "Robin Hammond" wrote:
>
> > It's a possible solution if you think that your users will be prepared
to
> > trust all your macros, and it can make life easier for you with your own
> > code. You need to look for SelfCert.exe from memory. It should be in
your
> > office folder.
> >
> > Alternatively, you can put your code in an add-in, and once the user has
> > elected to load the add-in the macro warning on that file won't be
shown.
> >
> > Robin Hammond
> > www.enhanceddatasystems.com
> >
> >
> > "Valeria" <[email protected]> wrote in message
> > news:[email protected]...
> > > Thanks!
> > > It works very well...
> > > just for curiosity: searching the posts, I have also found as an
option
> > > the
> > > digital certificate, so that basically users will be prompted only
once to
> > > enable macros written by you.
> > > With the premises that I do not know anything about this subject, is
it
> > > something you would also suggest?
> > > Thanks!
> > > Valeria
> > >
> > >
> > >
> > > "Bob Phillips" wrote:
> > >
> > >> Valeria,
> > >>
> > >> If you add a macro called Auto_Open, that runs when you open a
workbook.
> > >>
> > >> On the other point, the most common way of handling that is to have a
> > >> worksheet that puts up a message about disabling macros, and then
hide
> > >> all
> > >> other sheets. In your auto-open macro, hide this sheet and unhide the
> > >> rest.
> > >> If they disable macros, they will see this sheet, if they don't, they
> > >> will
> > >> not. Not foolproof, b ut a technique.
> > >>
> > >> --
> > >> HTH
> > >>
> > >> -------
> > >>
> > >> Bob Phillips
> > >> "Valeria" <[email protected]> wrote in message
> > >> news:[email protected]...
> > >> > Dear experts,
> > >> > is there a way I can force users to enable macros when they open a
> > >> > certain
> > >> > workbook, or at least provoke a warning message if they disable
them?
> > >> > Thanks!
> > >> > Best regards,
> > >> > --
> > >> > Valeria
> > >>
> > >>
> > >>
> >
> >
> >

Hi,
I am running Excel 2002 under Windows XP. I have re-run the installation
process to find the SelfCert.exe file, but anywhere I look I can't find it,
even as explained on the microsoft link in the "add/remove" programs...
Thanks
Valeria

"Tom Ogilvy" wrote:

> What version of Excel. You would need xl2000 or later. Also, when
> installing office, there are installation options and everything is not
> installed by default.
>
> See this for a more complete answer:
>
> http://support.microsoft.com/default...b;en-us;217221
> OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Valeria" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> > I have looked for the SelfCert.exe file but I can;'t find it, neither in
> my
> > office folder, nor in my whole C drive. Is this normal? Do I need to
> import
> > it from somewhere?
> > Thanks!
> > Valeria
> >
> > "Robin Hammond" wrote:
> >
> > > It's a possible solution if you think that your users will be prepared
> to
> > > trust all your macros, and it can make life easier for you with your own
> > > code. You need to look for SelfCert.exe from memory. It should be in
> your
> > > office folder.
> > >
> > > Alternatively, you can put your code in an add-in, and once the user has
> > > elected to load the add-in the macro warning on that file won't be
> shown.
> > >
> > > Robin Hammond
> > > www.enhanceddatasystems.com
> > >
> > >
> > > "Valeria" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > Thanks!
> > > > It works very well...
> > > > just for curiosity: searching the posts, I have also found as an
> option
> > > > the
> > > > digital certificate, so that basically users will be prompted only
> once to
> > > > enable macros written by you.
> > > > With the premises that I do not know anything about this subject, is
> it
> > > > something you would also suggest?
> > > > Thanks!
> > > > Valeria
> > > >
> > > >
> > > >
> > > > "Bob Phillips" wrote:
> > > >
> > > >> Valeria,
> > > >>
> > > >> If you add a macro called Auto_Open, that runs when you open a
> workbook.
> > > >>
> > > >> On the other point, the most common way of handling that is to have a
> > > >> worksheet that puts up a message about disabling macros, and then
> hide
> > > >> all
> > > >> other sheets. In your auto-open macro, hide this sheet and unhide the
> > > >> rest.
> > > >> If they disable macros, they will see this sheet, if they don't, they
> > > >> will
> > > >> not. Not foolproof, b ut a technique.
> > > >>
> > > >> --
> > > >> HTH
> > > >>
> > > >> -------
> > > >>
> > > >> Bob Phillips
> > > >> "Valeria" <[email protected]> wrote in message
> > > >> news:[email protected]...
> > > >> > Dear experts,
> > > >> > is there a way I can force users to enable macros when they open a
> > > >> > certain
> > > >> > workbook, or at least provoke a warning message if they disable
> them?
> > > >> > Thanks!
> > > >> > Best regards,
> > > >> > --
> > > >> > Valeria
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >
>
>
>

Here is one specific to xl2002/Office XP

http://office.microsoft.com/en-us/as...872981033.aspx

Maybe that will make a difference.

--
Regards,
Tom Ogilvy

"Valeria" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> I am running Excel 2002 under Windows XP. I have re-run the installation
> process to find the SelfCert.exe file, but anywhere I look I can't find
it,
> even as explained on the microsoft link in the "add/remove" programs...
> Thanks
> Valeria
>
> "Tom Ogilvy" wrote:
>
> > What version of Excel. You would need xl2000 or later. Also, when
> > installing office, there are installation options and everything is not
> > installed by default.
> >
> > See this for a more complete answer:
> >
> > http://support.microsoft.com/default...b;en-us;217221
> > OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "Valeria" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi,
> > > I have looked for the SelfCert.exe file but I can;'t find it, neither
in
> > my
> > > office folder, nor in my whole C drive. Is this normal? Do I need to
> > import
> > > it from somewhere?
> > > Thanks!
> > > Valeria
> > >
> > > "Robin Hammond" wrote:
> > >
> > > > It's a possible solution if you think that your users will be
prepared
> > to
> > > > trust all your macros, and it can make life easier for you with your
own
> > > > code. You need to look for SelfCert.exe from memory. It should be in
> > your
> > > > office folder.
> > > >
> > > > Alternatively, you can put your code in an add-in, and once the user
has
> > > > elected to load the add-in the macro warning on that file won't be
> > shown.
> > > >
> > > > Robin Hammond
> > > > www.enhanceddatasystems.com
> > > >
> > > >
> > > > "Valeria" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > Thanks!
> > > > > It works very well...
> > > > > just for curiosity: searching the posts, I have also found as an
> > option
> > > > > the
> > > > > digital certificate, so that basically users will be prompted only
> > once to
> > > > > enable macros written by you.
> > > > > With the premises that I do not know anything about this subject,
is
> > it
> > > > > something you would also suggest?
> > > > > Thanks!
> > > > > Valeria
> > > > >
> > > > >
> > > > >
> > > > > "Bob Phillips" wrote:
> > > > >
> > > > >> Valeria,
> > > > >>
> > > > >> If you add a macro called Auto_Open, that runs when you open a
> > workbook.
> > > > >>
> > > > >> On the other point, the most common way of handling that is to
have a
> > > > >> worksheet that puts up a message about disabling macros, and then
> > hide
> > > > >> all
> > > > >> other sheets. In your auto-open macro, hide this sheet and unhide
the
> > > > >> rest.
> > > > >> If they disable macros, they will see this sheet, if they don't,
they
> > > > >> will
> > > > >> not. Not foolproof, b ut a technique.
> > > > >>
> > > > >> --
> > > > >> HTH
> > > > >>
> > > > >> -------
> > > > >>
> > > > >> Bob Phillips
> > > > >> "Valeria" <[email protected]> wrote in message
> > > > >> news:[email protected]...
> > > > >> > Dear experts,
> > > > >> > is there a way I can force users to enable macros when they
open a
> > > > >> > certain
> > > > >> > workbook, or at least provoke a warning message if they disable
> > them?
> > > > >> > Thanks!
> > > > >> > Best regards,
> > > > >> > --
> > > > >> > Valeria
> > > > >>
> > > > >>
> > > > >>
> > > >
> > > >
> > > >
> >
> >
> >

Hi Tom,
this has really made the difference, it works now, thank you very much!
Kind regards,
Valeria

"Tom Ogilvy" wrote:

> Here is one specific to xl2002/Office XP
>
> http://office.microsoft.com/en-us/as...872981033.aspx
>
> Maybe that will make a difference.
>
> --
> Regards,
> Tom Ogilvy
>
> "Valeria" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> > I am running Excel 2002 under Windows XP. I have re-run the installation
> > process to find the SelfCert.exe file, but anywhere I look I can't find
> it,
> > even as explained on the microsoft link in the "add/remove" programs...
> > Thanks
> > Valeria
> >
> > "Tom Ogilvy" wrote:
> >
> > > What version of Excel. You would need xl2000 or later. Also, when
> > > installing office, there are installation options and everything is not
> > > installed by default.
> > >
> > > See this for a more complete answer:
> > >
> > > http://support.microsoft.com/default...b;en-us;217221
> > > OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > >
> > > "Valeria" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > Hi,
> > > > I have looked for the SelfCert.exe file but I can;'t find it, neither
> in
> > > my
> > > > office folder, nor in my whole C drive. Is this normal? Do I need to
> > > import
> > > > it from somewhere?
> > > > Thanks!
> > > > Valeria
> > > >
> > > > "Robin Hammond" wrote:
> > > >
> > > > > It's a possible solution if you think that your users will be
> prepared
> > > to
> > > > > trust all your macros, and it can make life easier for you with your
> own
> > > > > code. You need to look for SelfCert.exe from memory. It should be in
> > > your
> > > > > office folder.
> > > > >
> > > > > Alternatively, you can put your code in an add-in, and once the user
> has
> > > > > elected to load the add-in the macro warning on that file won't be
> > > shown.
> > > > >
> > > > > Robin Hammond
> > > > > www.enhanceddatasystems.com
> > > > >
> > > > >
> > > > > "Valeria" <[email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > > Thanks!
> > > > > > It works very well...
> > > > > > just for curiosity: searching the posts, I have also found as an
> > > option
> > > > > > the
> > > > > > digital certificate, so that basically users will be prompted only
> > > once to
> > > > > > enable macros written by you.
> > > > > > With the premises that I do not know anything about this subject,
> is
> > > it
> > > > > > something you would also suggest?
> > > > > > Thanks!
> > > > > > Valeria
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Bob Phillips" wrote:
> > > > > >
> > > > > >> Valeria,
> > > > > >>
> > > > > >> If you add a macro called Auto_Open, that runs when you open a
> > > workbook.
> > > > > >>
> > > > > >> On the other point, the most common way of handling that is to
> have a
> > > > > >> worksheet that puts up a message about disabling macros, and then
> > > hide
> > > > > >> all
> > > > > >> other sheets. In your auto-open macro, hide this sheet and unhide
> the
> > > > > >> rest.
> > > > > >> If they disable macros, they will see this sheet, if they don't,
> they
> > > > > >> will
> > > > > >> not. Not foolproof, b ut a technique.
> > > > > >>
> > > > > >> --
> > > > > >> HTH
> > > > > >>
> > > > > >> -------
> > > > > >>
> > > > > >> Bob Phillips
> > > > > >> "Valeria" <[email protected]> wrote in message
> > > > > >> news:[email protected]...
> > > > > >> > Dear experts,
> > > > > >> > is there a way I can force users to enable macros when they
> open a
> > > > > >> > certain
> > > > > >> > workbook, or at least provoke a warning message if they disable
> > > them?
> > > > > >> > Thanks!
> > > > > >> > Best regards,
> > > > > >> > --
> > > > > >> > Valeria
> > > > > >>
> > > > > >>
> > > > > >>
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>