Henry, Tom, et.al.,

Questions have been raised as to what the OP wanted and
we're spinning our wheels trying to figure it out.
Unless the OP posts back with a "Thank You" which would
be nice or some extra clarification as to what he wanted,
we're wasting our time in this thread.

John

Henry wrote:

John,

Look at the OP again.
"I believe that you can't bypass........"
I've told him how he *can* bypass the warning dialog.

I read the second sentance as:
Is there a way I can
put a message on there to advise (users that) the program will not
run unless you enable macros...

There is no need for this if the warning dialog is bypassed and macros
enabled as default.

HTH
Henry

"John Wilson" wrote in message
...
Henry,

What the OP asked was.....
Is there a way I can put a message on there to advise the program will
not
run unless you enable macros.
I got the impression from that post that the OP was looking to make sure
that whomever opened his workbook had the macros enabled.

If you set the security for macros at the workbook level to low, when
*that*
workbook is opened (by whomever) the dialog doesn't appear.
I'm using Excel 2000. If I set the security level to "low", *all*
workbooks
will be opened with macros enabled (without a warning). It's an
"Application"
level setting and not a "per workbook" setting. I believe it's the same
for
XP also.

John

Henry wrote:

Tom,

Works for me - Win XP, Excel XP

I understood from the OP that he wants to get rid of the Enable/Disable
macros dialog box.
If you set the security for macros at the workbook level to low, when
*that*
workbook is opened (by whomever) the dialog doesn't appear. This doesn't
affect the security level of any other workbooks, which will still show
the
dialog box, unless the security level is changed for them as well. He
could,
of course, change all his excel workbooks' security levels and never see
the
dialogue.

Henry

"Tom Ogilvy" wrote in message
...
This is incorrect information. The workbook will not control the
users
security level.

Regards,
Tom Ogilvy


"Henry" wrote in message
...
Phil,

Open the Workbook.
Goto ToolsMacroSecurity and set the security option to low.
Save the workbook.
Your users won't get that warning any longer.
Macros will always be enabled.

HTH
Henry

"Phil Perry" wrote in message
...
I believe you can't bypass the initial screen in Excel
which asks you to select to disable macros (default button
for pete sake) or enable macros. Is there a way I can
put a message on there to advise the program will not
run unless you enable macros...or other procedure to
overcome this.
cheers