| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
force a macro to execute
Dear experts,
is there a way I can force users to enable macros when they open a certain workbook, or at least provoke a warning message if they disable them? Thanks! Best regards, -- Valeria |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
force a macro to execute
Valeria,
No, there is no way to force enabling of macros. But... Hide all the sheet in the workbook except for a single sheet with a warning in large text that the workbook won't work unless macros are enabled, and unhide the remaining sheets and hide the warning in an auto_open macro. Robin Hammond www.enhanceddatasystems.com "Valeria" wrote in message ... Dear experts, is there a way I can force users to enable macros when they open a certain workbook, or at least provoke a warning message if they disable them? Thanks! Best regards, -- Valeria |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
force a macro to execute
Valeria,
If you add a macro called Auto_Open, that runs when you open a workbook. On the other point, the most common way of handling that is to have a worksheet that puts up a message about disabling macros, and then hide all other sheets. In your auto-open macro, hide this sheet and unhide the rest. If they disable macros, they will see this sheet, if they don't, they will not. Not foolproof, b ut a technique. -- HTH ------- Bob Phillips "Valeria" wrote in message ... Dear experts, is there a way I can force users to enable macros when they open a certain workbook, or at least provoke a warning message if they disable them? Thanks! Best regards, -- Valeria |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
force a macro to execute
Thanks!
It works very well... just for curiosity: searching the posts, I have also found as an option the digital certificate, so that basically users will be prompted only once to enable macros written by you. With the premises that I do not know anything about this subject, is it something you would also suggest? Thanks! Valeria "Bob Phillips" wrote: Valeria, If you add a macro called Auto_Open, that runs when you open a workbook. On the other point, the most common way of handling that is to have a worksheet that puts up a message about disabling macros, and then hide all other sheets. In your auto-open macro, hide this sheet and unhide the rest. If they disable macros, they will see this sheet, if they don't, they will not. Not foolproof, b ut a technique. -- HTH ------- Bob Phillips "Valeria" wrote in message ... Dear experts, is there a way I can force users to enable macros when they open a certain workbook, or at least provoke a warning message if they disable them? Thanks! Best regards, -- Valeria |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
force a macro to execute
It's a possible solution if you think that your users will be prepared to
trust all your macros, and it can make life easier for you with your own code. You need to look for SelfCert.exe from memory. It should be in your office folder. Alternatively, you can put your code in an add-in, and once the user has elected to load the add-in the macro warning on that file won't be shown. Robin Hammond www.enhanceddatasystems.com "Valeria" wrote in message ... Thanks! It works very well... just for curiosity: searching the posts, I have also found as an option the digital certificate, so that basically users will be prompted only once to enable macros written by you. With the premises that I do not know anything about this subject, is it something you would also suggest? Thanks! Valeria "Bob Phillips" wrote: Valeria, If you add a macro called Auto_Open, that runs when you open a workbook. On the other point, the most common way of handling that is to have a worksheet that puts up a message about disabling macros, and then hide all other sheets. In your auto-open macro, hide this sheet and unhide the rest. If they disable macros, they will see this sheet, if they don't, they will not. Not foolproof, b ut a technique. -- HTH ------- Bob Phillips "Valeria" wrote in message ... Dear experts, is there a way I can force users to enable macros when they open a certain workbook, or at least provoke a warning message if they disable them? Thanks! Best regards, -- Valeria |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
force a macro to execute
Hi,
I have looked for the SelfCert.exe file but I can;'t find it, neither in my office folder, nor in my whole C drive. Is this normal? Do I need to import it from somewhere? Thanks! Valeria "Robin Hammond" wrote: It's a possible solution if you think that your users will be prepared to trust all your macros, and it can make life easier for you with your own code. You need to look for SelfCert.exe from memory. It should be in your office folder. Alternatively, you can put your code in an add-in, and once the user has elected to load the add-in the macro warning on that file won't be shown. Robin Hammond www.enhanceddatasystems.com "Valeria" wrote in message ... Thanks! It works very well... just for curiosity: searching the posts, I have also found as an option the digital certificate, so that basically users will be prompted only once to enable macros written by you. With the premises that I do not know anything about this subject, is it something you would also suggest? Thanks! Valeria "Bob Phillips" wrote: Valeria, If you add a macro called Auto_Open, that runs when you open a workbook. On the other point, the most common way of handling that is to have a worksheet that puts up a message about disabling macros, and then hide all other sheets. In your auto-open macro, hide this sheet and unhide the rest. If they disable macros, they will see this sheet, if they don't, they will not. Not foolproof, b ut a technique. -- HTH ------- Bob Phillips "Valeria" wrote in message ... Dear experts, is there a way I can force users to enable macros when they open a certain workbook, or at least provoke a warning message if they disable them? Thanks! Best regards, -- Valeria |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
force a macro to execute
What version of Excel. You would need xl2000 or later. Also, when
installing office, there are installation options and everything is not installed by default. See this for a more complete answer: http://support.microsoft.com/default...b;en-us;217221 OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects -- Regards, Tom Ogilvy "Valeria" wrote in message ... Hi, I have looked for the SelfCert.exe file but I can;'t find it, neither in my office folder, nor in my whole C drive. Is this normal? Do I need to import it from somewhere? Thanks! Valeria "Robin Hammond" wrote: It's a possible solution if you think that your users will be prepared to trust all your macros, and it can make life easier for you with your own code. You need to look for SelfCert.exe from memory. It should be in your office folder. Alternatively, you can put your code in an add-in, and once the user has elected to load the add-in the macro warning on that file won't be shown. Robin Hammond www.enhanceddatasystems.com "Valeria" wrote in message ... Thanks! It works very well... just for curiosity: searching the posts, I have also found as an option the digital certificate, so that basically users will be prompted only once to enable macros written by you. With the premises that I do not know anything about this subject, is it something you would also suggest? Thanks! Valeria "Bob Phillips" wrote: Valeria, If you add a macro called Auto_Open, that runs when you open a workbook. On the other point, the most common way of handling that is to have a worksheet that puts up a message about disabling macros, and then hide all other sheets. In your auto-open macro, hide this sheet and unhide the rest. If they disable macros, they will see this sheet, if they don't, they will not. Not foolproof, b ut a technique. -- HTH ------- Bob Phillips "Valeria" wrote in message ... Dear experts, is there a way I can force users to enable macros when they open a certain workbook, or at least provoke a warning message if they disable them? Thanks! Best regards, -- Valeria |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
force a macro to execute
Hi,
I am running Excel 2002 under Windows XP. I have re-run the installation process to find the SelfCert.exe file, but anywhere I look I can't find it, even as explained on the microsoft link in the "add/remove" programs... Thanks Valeria "Tom Ogilvy" wrote: What version of Excel. You would need xl2000 or later. Also, when installing office, there are installation options and everything is not installed by default. See this for a more complete answer: http://support.microsoft.com/default...b;en-us;217221 OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects -- Regards, Tom Ogilvy "Valeria" wrote in message ... Hi, I have looked for the SelfCert.exe file but I can;'t find it, neither in my office folder, nor in my whole C drive. Is this normal? Do I need to import it from somewhere? Thanks! Valeria "Robin Hammond" wrote: It's a possible solution if you think that your users will be prepared to trust all your macros, and it can make life easier for you with your own code. You need to look for SelfCert.exe from memory. It should be in your office folder. Alternatively, you can put your code in an add-in, and once the user has elected to load the add-in the macro warning on that file won't be shown. Robin Hammond www.enhanceddatasystems.com "Valeria" wrote in message ... Thanks! It works very well... just for curiosity: searching the posts, I have also found as an option the digital certificate, so that basically users will be prompted only once to enable macros written by you. With the premises that I do not know anything about this subject, is it something you would also suggest? Thanks! Valeria "Bob Phillips" wrote: Valeria, If you add a macro called Auto_Open, that runs when you open a workbook. On the other point, the most common way of handling that is to have a worksheet that puts up a message about disabling macros, and then hide all other sheets. In your auto-open macro, hide this sheet and unhide the rest. If they disable macros, they will see this sheet, if they don't, they will not. Not foolproof, b ut a technique. -- HTH ------- Bob Phillips "Valeria" wrote in message ... Dear experts, is there a way I can force users to enable macros when they open a certain workbook, or at least provoke a warning message if they disable them? Thanks! Best regards, -- Valeria |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
force a macro to execute
Here is one specific to xl2002/Office XP
http://office.microsoft.com/en-us/as...872981033.aspx Maybe that will make a difference. -- Regards, Tom Ogilvy "Valeria" wrote in message ... Hi, I am running Excel 2002 under Windows XP. I have re-run the installation process to find the SelfCert.exe file, but anywhere I look I can't find it, even as explained on the microsoft link in the "add/remove" programs... Thanks Valeria "Tom Ogilvy" wrote: What version of Excel. You would need xl2000 or later. Also, when installing office, there are installation options and everything is not installed by default. See this for a more complete answer: http://support.microsoft.com/default...b;en-us;217221 OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects -- Regards, Tom Ogilvy "Valeria" wrote in message ... Hi, I have looked for the SelfCert.exe file but I can;'t find it, neither in my office folder, nor in my whole C drive. Is this normal? Do I need to import it from somewhere? Thanks! Valeria "Robin Hammond" wrote: It's a possible solution if you think that your users will be prepared to trust all your macros, and it can make life easier for you with your own code. You need to look for SelfCert.exe from memory. It should be in your office folder. Alternatively, you can put your code in an add-in, and once the user has elected to load the add-in the macro warning on that file won't be shown. Robin Hammond www.enhanceddatasystems.com "Valeria" wrote in message ... Thanks! It works very well... just for curiosity: searching the posts, I have also found as an option the digital certificate, so that basically users will be prompted only once to enable macros written by you. With the premises that I do not know anything about this subject, is it something you would also suggest? Thanks! Valeria "Bob Phillips" wrote: Valeria, If you add a macro called Auto_Open, that runs when you open a workbook. On the other point, the most common way of handling that is to have a worksheet that puts up a message about disabling macros, and then hide all other sheets. In your auto-open macro, hide this sheet and unhide the rest. If they disable macros, they will see this sheet, if they don't, they will not. Not foolproof, b ut a technique. -- HTH ------- Bob Phillips "Valeria" wrote in message ... Dear experts, is there a way I can force users to enable macros when they open a certain workbook, or at least provoke a warning message if they disable them? Thanks! Best regards, -- Valeria |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
force a macro to execute
Hi Tom,
this has really made the difference, it works now, thank you very much! Kind regards, Valeria "Tom Ogilvy" wrote: Here is one specific to xl2002/Office XP http://office.microsoft.com/en-us/as...872981033.aspx Maybe that will make a difference. -- Regards, Tom Ogilvy "Valeria" wrote in message ... Hi, I am running Excel 2002 under Windows XP. I have re-run the installation process to find the SelfCert.exe file, but anywhere I look I can't find it, even as explained on the microsoft link in the "add/remove" programs... Thanks Valeria "Tom Ogilvy" wrote: What version of Excel. You would need xl2000 or later. Also, when installing office, there are installation options and everything is not installed by default. See this for a more complete answer: http://support.microsoft.com/default...b;en-us;217221 OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects -- Regards, Tom Ogilvy "Valeria" wrote in message ... Hi, I have looked for the SelfCert.exe file but I can;'t find it, neither in my office folder, nor in my whole C drive. Is this normal? Do I need to import it from somewhere? Thanks! Valeria "Robin Hammond" wrote: It's a possible solution if you think that your users will be prepared to trust all your macros, and it can make life easier for you with your own code. You need to look for SelfCert.exe from memory. It should be in your office folder. Alternatively, you can put your code in an add-in, and once the user has elected to load the add-in the macro warning on that file won't be shown. Robin Hammond www.enhanceddatasystems.com "Valeria" wrote in message ... Thanks! It works very well... just for curiosity: searching the posts, I have also found as an option the digital certificate, so that basically users will be prompted only once to enable macros written by you. With the premises that I do not know anything about this subject, is it something you would also suggest? Thanks! Valeria "Bob Phillips" wrote: Valeria, If you add a macro called Auto_Open, that runs when you open a workbook. On the other point, the most common way of handling that is to have a worksheet that puts up a message about disabling macros, and then hide all other sheets. In your auto-open macro, hide this sheet and unhide the rest. If they disable macros, they will see this sheet, if they don't, they will not. Not foolproof, b ut a technique. -- HTH ------- Bob Phillips "Valeria" wrote in message ... Dear experts, is there a way I can force users to enable macros when they open a certain workbook, or at least provoke a warning message if they disable them? Thanks! Best regards, -- Valeria |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Execute Macro | Excel Worksheet Functions | |||
| Auto-execute macro.... | Excel Discussion (Misc queries) | |||
| Execute Macro | Excel Discussion (Misc queries) | |||
| Execute a query from a macro | Excel Programming | |||
| button to execute macro | Excel Programming | |||
Linear Mode
