Display Msg box on open "before" MS Macro Security warning display

I have tried the suggestions mentioned but the MS Macro Security Warning
"always" displays first.

I want to display a message box to the user on open "before" the MS macro
warning displays to remind them to answer yes to the MS macro warning rather
than have them restart Excel because they forgot to click yes.

Any luck in beating MS to the punch here?

Thanks
Jack

You need to run code to display a message box or userform; the macro security
warning is designed to prevent code from running without authorizing it
first. Sorry.

"Jack_Feeman" wrote:

> I have tried the suggestions mentioned but the MS Macro Security Warning
> "always" displays first.
>
> I want to display a message box to the user on open "before" the MS macro
> warning displays to remind them to answer yes to the MS macro warning rather
> than have them restart Excel because they forgot to click yes.
>
> Any luck in beating MS to the punch here?
>
> Thanks
> Jack

In xl2000 or later, you would need to certify your project and have the user
accept you as a trusted source.

An alternative would be to put your code in an addin and have the user load
the addin.

--
Regards,
Tom Ogilvy

"Jack_Feeman" <JackFeeman@discussions.microsoft.com> wrote in message
news:E9A6F657-5046-4F8D-9889-7CF116726099@microsoft.com...
> I have tried the suggestions mentioned but the MS Macro Security Warning
> "always" displays first.
>
> I want to display a message box to the user on open "before" the MS macro
> warning displays to remind them to answer yes to the MS macro warning
rather
> than have them restart Excel because they forgot to click yes.
>
> Any luck in beating MS to the punch here?
>
> Thanks
> Jack

Hi Tom,

XL2003 will not trust a self-signed certificate on a machine that lacks
the private key for that certificate -- something that should be
present only on the machine that created the certificate.

Only third party certificates (read several hundred $$ each year for
individuals) work.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <eGUDC$9KFHA.1396@TK2MSFTNGP10.phx.gbl>, twogilvy@msn.com
says...
> In xl2000 or later, you would need to certify your project and have the user
> accept you as a trusted source.
>
> An alternative would be to put your code in an addin and have the user load
> the addin.
>
>

Thanks everyone for the input. It is what I figured. Was just hoping someone
knew how to tap into the macro warning message to amend it to read "by not
selecting OK" the template will not work or similar message. I was trying to
help new users to understand saying no would make the template unusable. So I
will have to display this information in the instructions (who reads them
anyway?) for the template. Thanks again all.
Jack

"Tushar Mehta" wrote:

> Hi Tom,
>
> XL2003 will not trust a self-signed certificate on a machine that lacks
> the private key for that certificate -- something that should be
> present only on the machine that created the certificate.
>
> Only third party certificates (read several hundred $$ each year for
> individuals) work.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <eGUDC$9KFHA.1396@TK2MSFTNGP10.phx.gbl>, twogilvy@msn.com
> says...
> > In xl2000 or later, you would need to certify your project and have the user
> > accept you as a trusted source.
> >
> > An alternative would be to put your code in an addin and have the user load
> > the addin.
> >
> >
>

I know - I feel your pain. The MS written Macro warning is (IMHO) fairly
typically written in language that only the experienced geek like me would
understand; to the typical user it is unintelligible and scary and the
natural tendency is to want to say no, don't let these dangerous things
happen on my computer! I work at a hospital, I develop data analysis tools
that I distribute for nursing directors, etc. to use, and often they are only
used monthly or quarterly - too infrequently for them to remember what the
message means or how to respond. Or (adding to the fun) sometimes our MIS
people will push down something through the network that resets all the Excel
default settings, including setting macro security to high so the prompt
doesn't even show. I just love those calls... "I pushed the button, but
nothing happened! What do I do?" "Well, see your Tools menu... That's up at
the top of the screen. No, up near where it says...."

Hey, gotta vent every now and then! At least you folks will understand!
K Dales

"Jack_Feeman" wrote:

> Thanks everyone for the input. It is what I figured. Was just hoping someone
> knew how to tap into the macro warning message to amend it to read "by not
> selecting OK" the template will not work or similar message. I was trying to
> help new users to understand saying no would make the template unusable. So I
> will have to display this information in the instructions (who reads them
> anyway?) for the template. Thanks again all.
> Jack
>
> "Tushar Mehta" wrote:
>
> > Hi Tom,
> >
> > XL2003 will not trust a self-signed certificate on a machine that lacks
> > the private key for that certificate -- something that should be
> > present only on the machine that created the certificate.
> >
> > Only third party certificates (read several hundred $$ each year for
> > individuals) work.
> >
> > --
> > Regards,
> >
> > Tushar Mehta
> > www.tushar-mehta.com
> > Excel, PowerPoint, and VBA add-ins, tutorials
> > Custom MS Office productivity solutions
> >
> > In article <eGUDC$9KFHA.1396@TK2MSFTNGP10.phx.gbl>, twogilvy@msn.com
> > says...
> > > In xl2000 or later, you would need to certify your project and have the user
> > > accept you as a trusted source.
> > >
> > > An alternative would be to put your code in an addin and have the user load
> > > the addin.
> > >
> > >
> >

Thanks for the added - I assume this is added info as I didn't mention using
self-cert which is what I think you are referring to. But there wouldn't be
any reason to suppress the prompt unless they were making the big commercial
dollars distributing their application or doing it for their equally
prosperous business.

for the OP. the usual suggestion if you don't fit in the above, is to hide
your sheets and have your macro unhide them (all but one with a message that
macros need to be enabled). Also, your macro has to hide them in the
beforeclose and beforesave events (and save the workbook) in preparation
for the next opening. the disadvantage being that when workbook users screw
up, a lot of time they want close the workbook without saving.

--
Regards,
Tom Ogilvy

"Tushar Mehta" <tmUnderscore200310@tushar-mehta.SeeOhEm> wrote in message
news:MPG.1ca4df64316706b298af21@msnews.microsoft.com...
> Hi Tom,
>
> XL2003 will not trust a self-signed certificate on a machine that lacks
> the private key for that certificate -- something that should be
> present only on the machine that created the certificate.
>
> Only third party certificates (read several hundred $$ each year for
> individuals) work.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <eGUDC$9KFHA.1396@TK2MSFTNGP10.phx.gbl>, twogilvy@msn.com
> says...
> > In xl2000 or later, you would need to certify your project and have the
user
> > accept you as a trusted source.
> >
> > An alternative would be to put your code in an addin and have the user
load
> > the addin.
> >
> >