LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Enable Macros with No Prompt

For completeness, you can certify your code and if the user accepts you as a
trusted source, then the prompt will not be rendered for further openings
(xl2000 and later).

http://msdn.microsoft.com/library/de.../odc_dsvba.asp
Code Signing Office XP Visual Basic for Applications Macro Projects

http://support.microsoft.com/default...;en-us;Q288985
XL2002: About Digital Signatures in Excel Workbooks


http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
(Q217221)



An Overview:
http://msdn.microsoft.com/library/de...tml/combat.asp

Another reference:
http://msdn.microsoft.com/library/en...vbaproject.asp



http://support.microsoft.com/default...;en-us;Q329228
OFFXP: How to Make Sure That Your Office Document Has a Valid Digital
Signature


http://office.microsoft.com/assistan...ustworthy.aspx
How to Tell if Digital Certificate Is Trustworthy in Office XP


--
Regards,
Tom Ogilvy

"Beau" wrote in message
...
Hello,
How do you select "Enable Macros" when Excel starts
without prompting the user? I'm a little new to Excel
programming. I don't want to give the user the option.
Thanks.

Beau



 
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 2007 Enable Macro Prompt TheCornjerker Excel Discussion (Misc queries) 0 February 4th 08 04:59 PM
Enable macros? Steve Excel Worksheet Functions 2 October 14th 05 04:17 PM
How do I enable Excel's "formula prompt?" Amalpert Excel Discussion (Misc queries) 1 September 22nd 05 07:06 PM
can not enable macros Tricia Excel Worksheet Functions 2 August 24th 05 11:18 PM
remove enable macro prompt Redden Excel Discussion (Misc queries) 1 August 17th 05 12:16 PM


All times are GMT +1. The time now is 10:43 AM.

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"