ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   start application / macro warning problem (https://www.excelbanter.com/excel-programming/344377-start-application-macro-warning-problem.html)

Pierre via OfficeKB.com[_2_]

start application / macro warning problem
 
Hi experts,

I have built an application with macro's.
However when the security level for macro's is too high it won't start the
macro's and i end up in the file without the macro's.

What i would like is just a message that the macro security level is too high
and then quit the application before it even opens...

Any ideas?
Thanks,
Pierre


--
Message posted via http://www.officekb.com

Kassie

start application / macro warning problem
 
Hi Pierre

Have you tried to digitally sign your macros, and then setting your macro
security level to High? It will then ask you if you want to accept the
signature, after which macros from yourself, which are so signed, will always
work.
--
ve_2nd_at. Stilfontein, Northwest, South Africa


"Pierre via OfficeKB.com" wrote:

Hi experts,

I have built an application with macro's.
However when the security level for macro's is too high it won't start the
macro's and i end up in the file without the macro's.

What i would like is just a message that the macro security level is too high
and then quit the application before it even opens...

Any ideas?
Thanks,
Pierre


--
Message posted via
http://www.officekb.com


Bob Phillips[_6_]

start application / macro warning problem
 
Pierre,

Take a look at http://tinyurl.com/dflwx for a technique

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:56b8f360a817a@uwe...
Hi experts,

I have built an application with macro's.
However when the security level for macro's is too high it won't start the
macro's and i end up in the file without the macro's.

What i would like is just a message that the macro security level is too

high
and then quit the application before it even opens...

Any ideas?
Thanks,
Pierre


--
Message posted via http://www.officekb.com




Pierre via OfficeKB.com[_2_]

start application / macro warning problem
 
Hi Kassie,

Yep i did but that only works on my pc and not with the many pc's my users
work on...
thanks,
Pierre

Kassie wrote:
Hi Pierre

Have you tried to digitally sign your macros, and then setting your macro
security level to High? It will then ask you if you want to accept the
signature, after which macros from yourself, which are so signed, will always
work.
Hi experts,

[quoted text clipped - 8 lines]
Thanks,
Pierre



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1


All times are GMT +1. The time now is 02:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com