Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink question
Hi,
I have a hyperlink that open another workbook containing macro. Is there a way to change the behavior of the hyperlink so that when it opens the file, it can skip the dialog box of "Enable" or "Disable" Macro? I don't want my user to keep clicking on the "Enable Macro" everytime it opens. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink question
First you must accept the fact that macros can be a bad security risk to the
user if written with malicious intent. Not that you would, but they are out there. The user has 3 levels of macro security to choose from: Run no macros (High), Let me decide (Medium), and Run All Macros (Low). You or no code you can write, have any control over what level the user has chosen. If the user has chosen Low security, then your workbook with macros will open and run with no pop-up dialog box. I know of no one who uses this setting, nor would I ever ask a user to choose this setting just to run one of my workbooks. So, to answer your question, the answer is 99.9% NO. However, there is an alternative called Digital Signature. You can read up on it in the Help files. Basically you create a digital signature that you can sign your project code with. When a user opens your signed workbook, they will be asked to add you to their trusted sources. Once they add your signature to their trusted sources, your workbook code will run, no questions asked, no matter what security level the user has chosen. This is probably your best and only alternative here. The user still gets that initial first time pop-up to add you to their trusted sources. Also remember that each workbook you want opened this way that has macros in it, must have your signature attached to it. A hyperlink to open another workbook means that the other workbook must have your signature also. Good Luck, Mike F "matelot" wrote in message ... Hi, I have a hyperlink that open another workbook containing macro. Is there a way to change the behavior of the hyperlink so that when it opens the file, it can skip the dialog box of "Enable" or "Disable" Macro? I don't want my user to keep clicking on the "Enable Macro" everytime it opens. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink question
Mike,
Thanks for the suggestion. I will look into it. Mat "Mike Fogleman" wrote: First you must accept the fact that macros can be a bad security risk to the user if written with malicious intent. Not that you would, but they are out there. The user has 3 levels of macro security to choose from: Run no macros (High), Let me decide (Medium), and Run All Macros (Low). You or no code you can write, have any control over what level the user has chosen. If the user has chosen Low security, then your workbook with macros will open and run with no pop-up dialog box. I know of no one who uses this setting, nor would I ever ask a user to choose this setting just to run one of my workbooks. So, to answer your question, the answer is 99.9% NO. However, there is an alternative called Digital Signature. You can read up on it in the Help files. Basically you create a digital signature that you can sign your project code with. When a user opens your signed workbook, they will be asked to add you to their trusted sources. Once they add your signature to their trusted sources, your workbook code will run, no questions asked, no matter what security level the user has chosen. This is probably your best and only alternative here. The user still gets that initial first time pop-up to add you to their trusted sources. Also remember that each workbook you want opened this way that has macros in it, must have your signature attached to it. A hyperlink to open another workbook means that the other workbook must have your signature also. Good Luck, Mike F "matelot" wrote in message ... Hi, I have a hyperlink that open another workbook containing macro. Is there a way to change the behavior of the hyperlink so that when it opens the file, it can skip the dialog box of "Enable" or "Disable" Macro? I don't want my user to keep clicking on the "Enable Macro" everytime it opens. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Hyperlink question | Excel Worksheet Functions | |||
Hyperlink question | Excel Programming | |||
Hyperlink Question | Excel Discussion (Misc queries) | |||
Hyperlink question | Links and Linking in Excel | |||
hyperlink question | Excel Worksheet Functions |