Adding Code Module to Workbook
 

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

Adding Code Module to Workbook
 

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)


---
Message posted from http://www.ExcelForum.com/

Adding Code Module to Workbook
 

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

"Charles" wrote in message
...
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