Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2003 and tab colours | New Users to Excel | |||
Dev tools (VSS) in XL2003 | Excel Programming | |||
XL2003 Add Ins | Excel Programming | |||
xl2003 and VS | Excel Programming | |||
xl2003 | Excel Programming |