Macros loading under XL2003
 

My company has upgraded to XL2003, and I am forced to play 'catch up'. I
have only a few co-workers, so two
dedicated machines still run standalone with xl2k as a fallback, if needed.

Addins do not seem to be a problem, so far, but a few 'template' workbooks
(eg: an Order form, Fax form, etc)
are a problem.

They are not 'true' Templates or Forms, simply single-sheet books, with
code in the ThisWorkbook module.
When opened, I'm getting macro warning messages, and I can simply bypass the
code leaving me with a "useless" sheet.

My research suggests that a Certificate is required.
Can I create this myself, or must it be purchased?

If relevent, my co-workers Order/Fax is e-mailed to the intended recipient,
but Chip Pearson's code is 'borrowed'
to remove all code, before sending.

Can I resolve this easily and cheaply? Or perhaps I should consider moving
these 'templates' so that they become
options under the AddIns?

Advice much appreciated, please.

Regards.

Macros loading under XL2003
 

Can you not just go to "Tools-Macro-Security" and lower the setting to medium?
This will trigger the "do you want to allow macro's" dialogue.


--
Regards;
Rob
------------------------------------------------------------------------
"S G Booth" wrote in message
...
My company has upgraded to XL2003, and I am forced to play 'catch up'. I
have only a few co-workers, so two
dedicated machines still run standalone with xl2k as a fallback, if needed.

Addins do not seem to be a problem, so far, but a few 'template' workbooks
(eg: an Order form, Fax form, etc)
are a problem.

They are not 'true' Templates or Forms, simply single-sheet books, with
code in the ThisWorkbook module.
When opened, I'm getting macro warning messages, and I can simply bypass the
code leaving me with a "useless" sheet.

My research suggests that a Certificate is required.
Can I create this myself, or must it be purchased?

If relevent, my co-workers Order/Fax is e-mailed to the intended recipient,
but Chip Pearson's code is 'borrowed'
to remove all code, before sending.

Can I resolve this easily and cheaply? Or perhaps I should consider moving
these 'templates' so that they become
options under the AddIns?

Advice much appreciated, please.

Regards.

Macros loading under XL2003
 

Thanks for the reply.
I'm using the medium setting at the moment, but a High
setting would be preferable. In addition, with a medium
setting the user can always disable macros.

If it's not too difficult to achieve, then I really would like
to find another way.

Regards and thanks.

"RWN" wrote in message
...
Can you not just go to "Tools-Macro-Security" and lower the setting to
medium?
This will trigger the "do you want to allow macro's" dialogue.


--
Regards;
Rob
------------------------------------------------------------------------
"S G Booth" wrote in message
...
My company has upgraded to XL2003, and I am forced to play 'catch up'. I
have only a few co-workers, so two
dedicated machines still run standalone with xl2k as a fallback, if
needed.

Addins do not seem to be a problem, so far, but a few 'template'
workbooks
(eg: an Order form, Fax form, etc)
are a problem.

They are not 'true' Templates or Forms, simply single-sheet books, with
code in the ThisWorkbook module.
When opened, I'm getting macro warning messages, and I can simply bypass
the
code leaving me with a "useless" sheet.

My research suggests that a Certificate is required.
Can I create this myself, or must it be purchased?

If relevent, my co-workers Order/Fax is e-mailed to the intended
recipient,
but Chip Pearson's code is 'borrowed'
to remove all code, before sending.

Can I resolve this easily and cheaply? Or perhaps I should consider
moving
these 'templates' so that they become
options under the AddIns?

Advice much appreciated, please.

Regards.