Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Macros with No Prompt
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable Macros with No Prompt
The user is always given the option to enable or disable macros if they have
chosen the appropriate security level. This is for their self protection as their is no way to know if a macro is harmful or not. You can not overcome this prompt with code contained in the workbook where you don't want the prompt (in fact the prompt is given before any code is run). Think about it. If it could be turned of by code, then there really would be no reason to have the prompt. -- 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Enable Macro Prompt | Excel Discussion (Misc queries) | |||
Enable macros? | Excel Worksheet Functions | |||
How do I enable Excel's "formula prompt?" | Excel Discussion (Misc queries) | |||
can not enable macros | Excel Worksheet Functions | |||
remove enable macro prompt | Excel Discussion (Misc queries) |