LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
GB GB is offline
external usenet poster
 
Posts: 230
Default VBE Security

In the user environment that I have, I would like to be able to
programmatically change the macro security settings to check the Trust access
to Visual Basic Project when I run one procedure, but then at the completion
of that procedure to return the setting back to not trust (I.e., check the
block and uncheck it.) I have thought of at least one way to identify which
menu item I need to worry about through the use of an ID number or searching
through the CommandBars data; however, I have not figured out how to 1,
activate the window, or 2 perform any kind of manipulations to identify the
current status of the check box. I do know that if in the running of my code
that an error occurs that I need to get the box checked, but if the error
does not occur then the box is already checked.

It's a little obscure, but I am using VBE code to present a portion of the
VBE code when an added menu option is selected. Any assistance would be
appreciated. My concern is that users are not likely to restore the setting
upon completion of the program on their own. I can give them a warning, both
when they try to run it, and then another before closing out Excel; however,
I do not expect that users will take the necessary actions and I do not wish
to be the cause of some other malicious issue, if I can programmatically
prevent it.
 
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
Security dwake Excel Discussion (Misc queries) 5 December 21st 09 09:02 PM
security kyoshirou Excel Discussion (Misc queries) 5 July 3rd 07 06:27 AM
security tjh Excel Programming 2 October 18th 04 03:30 AM
VBA Security Dave[_46_] Excel Programming 1 September 26th 04 04:59 PM
Security... LC[_2_] Excel Programming 2 December 22nd 03 05:05 PM


All times are GMT +1. The time now is 10:30 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"