Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing "Macro Enable"
To: "Harald Staff" and "Bob Phillip
Thanks a lot for your time and help. It is very much appreciated. To: Harald - I am not trying to make the workbook useless w/o macros. I should have explained that what I am trying to do is create a macro that is started by a desktop icon. It goes out with "workbook open event" and looks for a file and if it finds it, it is to open it and close itself. What I want it to do is to open the file from the desktop icon without user interaction or manually enabling macros. As for ensuring that workbooks are useless without macros running, I agree and do so whenever needed. To Bob: You state. What you can do is have an information sheet which tells the user that macros need enabling for your workbook to function. - Isn't this exactly what excel does in the opening. I think this is what I want to bypass. As stated above I want the desktop icon to go directly to the open file. To All: I think I have had workbooks that open without user interaction. but I am unable to find them. Maybe I am nuts, but any additional help is appreciated. Regards, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing "Macro Enable"
Ronbo, you can set the security to low, not recommended, or if you are using
Excel 2000 or newer, sign the macro with a digital certificate -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "Ronbo" wrote in message ... To: "Harald Staff" and "Bob Phillip Thanks a lot for your time and help. It is very much appreciated. To: Harald - I am not trying to make the workbook useless w/o macros. I should have explained that what I am trying to do is create a macro that is started by a desktop icon. It goes out with "workbook open event" and looks for a file and if it finds it, it is to open it and close itself. What I want it to do is to open the file from the desktop icon without user interaction or manually enabling macros. As for ensuring that workbooks are useless without macros running, I agree and do so whenever needed. To Bob: You state. What you can do is have an information sheet which tells the user that macros need enabling for your workbook to function. - Isn't this exactly what excel does in the opening. I think this is what I want to bypass. As stated above I want the desktop icon to go directly to the open file. To All: I think I have had workbooks that open without user interaction. but I am unable to find them. Maybe I am nuts, but any additional help is appreciated. Regards, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing "Macro Enable"
Hi,
Is your startup macro named Auto_Open()? -- John johnf202 at hotmail dot com "Ronbo" wrote in message ... : To: "Harald Staff" and "Bob Phillip : : Thanks a lot for your time and help. It is very much : appreciated. : : To: Harald - : : I am not trying to make the workbook useless w/o macros. : I should have explained that what I am trying to do is : create a macro that is started by a desktop icon. It : goes out with "workbook open event" and looks for a file : and if it finds it, it is to open it and close itself. : What I want it to do is to open the file from the desktop : icon without user interaction or manually enabling macros. : : As for ensuring that workbooks are useless without macros : running, I agree and do so whenever needed. : : To Bob: : : You state. : : What you can do is have an information sheet which tells : the user that : macros need enabling for your workbook to function. - : : Isn't this exactly what excel does in the opening. I : think this is what I want to bypass. As stated above I : want the desktop icon to go directly to the open file. : : To All: I think I have had workbooks that open without : user interaction. but I am unable to find them. Maybe I : am nuts, but any additional help is appreciated. : : Regards, : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Macro "disable or enable" screen | Excel Discussion (Misc queries) | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Forcing "Macro Enable" | Excel Programming |