| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| code module? | Excel Worksheet Functions | |||
| Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
| code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
| copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
| code to add module | Excel Programming | |||
Linear Mode
