Adding Code Module to Workbook

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

Hi in office 97 I was able to use code in a master
workbook to add a code module with code to a workbook
created by this workbook, but we have now changed to xp
and this function falls over can someone tell me if this
can still be done in xp.
Charles
 
Hello,

In XP, we have to change the security setting.
From main tool bar, Tools > Macro > security.
At the second tab, press Alt + V key.
Sorry I don't have an English version, but the caption would be
something like this..(Trust access to a VBA project)
 
Charles,

It can still be done, but new security features protect that which could be
abused.

Play with the Security Levels. From Excel's menu: Tools | Macro |
Security...

Rob
 
Back
Top