Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 523
Default Forcing Macros to Run

Malicious code would exploit that. Search excel help etc for digital
signatures and see if any of that interests you.

Sam

"James" wrote:

I developed a spreadsheet that has vba code and I would like to make sure the
code always runs. I would like to either disable the prompt to disable/enable
macros when the spreadsheet opens or force the user to have to enable macros.
First when I try setting the security level to "Low" it doesn't save, it
reverts back to Medium. A second approach it to display a warning page if the
user selected "disable macros" and hide all the other pages. This is ok, but
the problem is I also have code that disables the menu items. Since they are
bypassing this they have access to the menu system. I might be making too
much of this, but is their a way to disable the menu items even when they do
not select "enable macros" and/or is their a way to force a user to have to
select "enable macros" or disable the prompt?
Thanks

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
forcing UDF to run Stefi Excel Worksheet Functions 4 December 29th 05 03:46 PM
Macros forcing file open brodine Excel Programming 2 July 29th 05 02:45 PM
Forcing MS Query to run before macros Dkline[_2_] Excel Programming 1 August 11th 04 05:08 PM
Forcing users to enable macros universal[_17_] Excel Programming 8 December 20th 03 03:14 PM
Forcing Macros to Run (Else Deny Access to Workbook) Alan Excel Programming 2 September 20th 03 12:03 PM


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

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

About Us

"It's about Microsoft Excel"