Excel Upgrade

[zwxphtt]

I upgraded my users (all of the are Power Users) to Office 2003 from
Office 2000 and now I get an error message "The workbook has lost its
VBA project, ActiveX controls and any other programmability-related
features". They have the full install running from thier computers. I
don't have the problem as an administrator but they ALL have the
problem as Power Users. None of the articles on the knowledge base
helped nor the help in the software. The problem is really obivious in
Excel. Its definitely a rights thing but I don't know which Hive key.
Anyone else seen this??

 

[Jim Rech]

Search on the key "VBAOff" in the registry. When its value is set to 1
under HKCU\Software\Microsoft\Office\11.0\Common and/or the equivalent HKLM
key I get the same message as you cited opening an Excel file with macros in
it. If that's not it I don't have any other ideas short of VB itself not
being installed (I think this is an admin install option).

--
Jim Rech
Excel MVP
|I upgraded my users (all of the are Power Users) to Office 2003 from
| Office 2000 and now I get an error message "The workbook has lost its
| VBA project, ActiveX controls and any other programmability-related
| features". They have the full install running from thier computers. I
| don't have the problem as an administrator but they ALL have the
| problem as Power Users. None of the articles on the knowledge base
| helped nor the help in the software. The problem is really obivious in
| Excel. Its definitely a rights thing but I don't know which Hive key.
| Anyone else seen this??