Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 122
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 122
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel application.quit in macro problem TimkenSteve New Users to Excel 3 August 17th 06 06:36 PM
Macro to Start an Application Joe Teixeira Excel Discussion (Misc queries) 3 April 26th 06 06:36 PM
Application.run Macro Code Problem Todd Huttenstine Excel Programming 1 August 21st 04 08:23 PM
Can i disable the warning when i open the my VBA application kvenku[_33_] Excel Programming 1 August 9th 04 12:20 PM
Empty ThisWorkbook module, but Macro warning problem Stuart[_5_] Excel Programming 3 June 28th 04 07:20 PM


All times are GMT +1. The time now is 07:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"