Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office 2007 Functionality
Through my company I was able to purchase Microsoft Office Enterprise 2007
that contains Word, Excel, Access, P Point, Outlook, ect. 2007. The CD cover says it is a "Home Use Program." I loaded Excel only. When I open 2007, it appears that it can not load macros, record macros, etc. When I select the Developer option on the menu bar, VB, Macros and Record Macro are all greyed out. Does this mean that this is a "watered down" version that just doesn't have all the functionality that Office Professional has? -- Ken Hudson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office 2007 Functionality
One more piece of information. When I loaded 2007, I kept the old version of
Excel 2003. Could that have caused the problem with VB? -- Ken Hudson "Ken Hudson" wrote: Through my company I was able to purchase Microsoft Office Enterprise 2007 that contains Word, Excel, Access, P Point, Outlook, ect. 2007. The CD cover says it is a "Home Use Program." I loaded Excel only. When I open 2007, it appears that it can not load macros, record macros, etc. When I select the Developer option on the menu bar, VB, Macros and Record Macro are all greyed out. Does this mean that this is a "watered down" version that just doesn't have all the functionality that Office Professional has? -- Ken Hudson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office 2007 Functionality
Hi Ken,
Rerun the installer, choose the custom installation option and make sure VBA is selected to be installed under the Shared Features list. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Ken Hudson" wrote in message ... Through my company I was able to purchase Microsoft Office Enterprise 2007 that contains Word, Excel, Access, P Point, Outlook, ect. 2007. The CD cover says it is a "Home Use Program." I loaded Excel only. When I open 2007, it appears that it can not load macros, record macros, etc. When I select the Developer option on the menu bar, VB, Macros and Record Macro are all greyed out. Does this mean that this is a "watered down" version that just doesn't have all the functionality that Office Professional has? -- Ken Hudson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office 2007 Functionality
There should be no conflict with xl03 and 07 being on the hard drive at the
same time. In xl2003, you could enable VBA by clicking ToolsMacroSecurityTrustedPublishers then check the boxes for trusting macros and vba. Don't know if that is in xl2007, but check it out. "Ken Hudson" wrote: One more piece of information. When I loaded 2007, I kept the old version of Excel 2003. Could that have caused the problem with VB? -- Ken Hudson "Ken Hudson" wrote: Through my company I was able to purchase Microsoft Office Enterprise 2007 that contains Word, Excel, Access, P Point, Outlook, ect. 2007. The CD cover says it is a "Home Use Program." I loaded Excel only. When I open 2007, it appears that it can not load macros, record macros, etc. When I select the Developer option on the menu bar, VB, Macros and Record Macro are all greyed out. Does this mean that this is a "watered down" version that just doesn't have all the functionality that Office Professional has? -- Ken Hudson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office 2007 Functionality
Thanks Rob!
That was it. I didn't realize that I had to install the Shared Features also. -- Ken Hudson "Rob Bovey" wrote: Hi Ken, Rerun the installer, choose the custom installation option and make sure VBA is selected to be installed under the Shared Features list. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm "Ken Hudson" wrote in message ... Through my company I was able to purchase Microsoft Office Enterprise 2007 that contains Word, Excel, Access, P Point, Outlook, ect. 2007. The CD cover says it is a "Home Use Program." I loaded Excel only. When I open 2007, it appears that it can not load macros, record macros, etc. When I select the Developer option on the menu bar, VB, Macros and Record Macro are all greyed out. Does this mean that this is a "watered down" version that just doesn't have all the functionality that Office Professional has? -- Ken Hudson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paint Brush - Functionality different in 2007 from 2003 | Excel Discussion (Misc queries) | |||
2007 to 2003 functionality | Excel Discussion (Misc queries) | |||
New Drop-Down Functionality in 2007? | Excel Worksheet Functions | |||
Functionality of Excel 2007 Home and Student Edition | Excel Discussion (Misc queries) | |||
Problem with Interop.Excel after uninstalling Office 2007 and installing Office 2003 | Excel Programming |