Forcing "Macro Enable"

R

Ronbo

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,
 
P

Paul B

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 **
 
J

jaf

Hi,
Is your startup macro named Auto_Open()?

--

John
johnf202 at hotmail dot com



: 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,
:
 
Top