macro's after transition office xp to office 2003

G

Gilbert De Ceulaer

I recently changed from office xp to office 2003
I have several workbook linked to each other an one of them contains a few
macro's that I - with much effort - concocted in VBA.
After the transition I always get an alarm about these macro's, and I can
only get them to work by lowering the security-level.
How can I make them work without the alarm, and - of course - without
lowering the security-level ?
Thanks in advance for an advice.
Gilbert
 
J

Jim Cone

Gilbert,
There are additional security levels in xl2003 vs. xl2002
Look at "About Macro Security" (or security) in Excel help.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Gilbert De Ceulaer"
<[email protected]>
wrote in message
I recently changed from office xp to office 2003
I have several workbook linked to each other an one of them contains a few
macro's that I - with much effort - concocted in VBA.
After the transition I always get an alarm about these macro's, and I can
only get them to work by lowering the security-level.
How can I make them work without the alarm, and - of course - without
lowering the security-level ?
Thanks in advance for an advice.
Gilbert
 
G

Gord Dibben

Gilbert

If the workbooks are to be used on just your own computer you can sign them
using the SelfCert tool.

See help on "selfcert".

Go to Start>Programs>Microsoft Office>Office Tools and build a selfcert from
there.

Once you get the certificate created, open your workbook and go to the VBE and
Tools>Digital Signature>Choose.

Pick the one you just created and OK then Save.

Close and re-open the workbook. The macro alert message will come up.

Enable the option "always trust this publisher" and enable macros.

Won't get that message next time you open the workbook.


Gord Dibben MS Excel MVP
 
Top