Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel application.quit in macro problem | New Users to Excel | |||
Macro to Start an Application | Excel Discussion (Misc queries) | |||
Application.run Macro Code Problem | Excel Programming | |||
Can i disable the warning when i open the my VBA application | Excel Programming | |||
Empty ThisWorkbook module, but Macro warning problem | Excel Programming |