Adding Code Module to Workbook

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
 
C

Colo

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)
 
R

Rob van Gelder

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
 
Top