| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code/form missing in Excel 2007
In Office 2003, I created an Excel file that includes a small form and some
VBA code. I want to use this same form and code in Excel 2007 - VSTO is not an option. But when I open the file and go to Developer, Visual Basic, there is no form and the code is blank. How do I get this file to function in Excel 2007? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA code/form missing in Excel 2007
Hi, what do you mean "go to Developer, Visual Basic"
I can't see a menu item for Developer? "megabite" wrote: In Office 2003, I created an Excel file that includes a small form and some VBA code. I want to use this same form and code in Excel 2007 - VSTO is not an option. But when I open the file and go to Developer, Visual Basic, there is no form and the code is blank. How do I get this file to function in Excel 2007? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA code/form missing in Excel 2007
Excel Options, Popular, check the box labeled "Show Developer tab in Ribbon"
"incre-d" wrote: Hi, what do you mean "go to Developer, Visual Basic" I can't see a menu item for Developer? "megabite" wrote: In Office 2003, I created an Excel file that includes a small form and some VBA code. I want to use this same form and code in Excel 2007 - VSTO is not an option. But when I open the file and go to Developer, Visual Basic, there is no form and the code is blank. How do I get this file to function in Excel 2007? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA code/form missing in Excel 2007
I still don't enjoy this 2007 stuff.
Are you looking in the correct proejct in the Visual Basic...? I just opened an excel 2003 sheet with form and code, and both show. "megabite" wrote: Excel Options, Popular, check the box labeled "Show Developer tab in Ribbon" "incre-d" wrote: Hi, what do you mean "go to Developer, Visual Basic" I can't see a menu item for Developer? "megabite" wrote: In Office 2003, I created an Excel file that includes a small form and some VBA code. I want to use this same form and code in Excel 2007 - VSTO is not an option. But when I open the file and go to Developer, Visual Basic, there is no form and the code is blank. How do I get this file to function in Excel 2007? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA code/form missing in Excel 2007
well that there is the question.
I open the file in 2003 on another computer , the code and form are there. I open the file in 2007, no code, no form. Why? Is it a security thing? I think I turned it all off. Compatibility bug? Something else? "incre-d" wrote: I still don't enjoy this 2007 stuff. Are you looking in the correct proejct in the Visual Basic...? I just opened an excel 2003 sheet with form and code, and both show. "megabite" wrote: Excel Options, Popular, check the box labeled "Show Developer tab in Ribbon" "incre-d" wrote: Hi, what do you mean "go to Developer, Visual Basic" I can't see a menu item for Developer? "megabite" wrote: In Office 2003, I created an Excel file that includes a small form and some VBA code. I want to use this same form and code in Excel 2007 - VSTO is not an option. But when I open the file and go to Developer, Visual Basic, there is no form and the code is blank. How do I get this file to function in Excel 2007? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA code/form missing in Excel 2007
Do you open the xls in 2007 ?
If you save the xls as a xlsx file in 2007 your code and form are gone. If you have done that save the xls as xlsm and try it again -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "megabite" wrote in message ... well that there is the question. I open the file in 2003 on another computer , the code and form are there. I open the file in 2007, no code, no form. Why? Is it a security thing? I think I turned it all off. Compatibility bug? Something else? "incre-d" wrote: I still don't enjoy this 2007 stuff. Are you looking in the correct proejct in the Visual Basic...? I just opened an excel 2003 sheet with form and code, and both show. "megabite" wrote: Excel Options, Popular, check the box labeled "Show Developer tab in Ribbon" "incre-d" wrote: Hi, what do you mean "go to Developer, Visual Basic" I can't see a menu item for Developer? "megabite" wrote: In Office 2003, I created an Excel file that includes a small form and some VBA code. I want to use this same form and code in Excel 2007 - VSTO is not an option. But when I open the file and go to Developer, Visual Basic, there is no form and the code is blank. How do I get this file to function in Excel 2007? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add-Ins tab missing in Excel 2007 | Setting up and Configuration of Excel | |||
| Missing Add-Ins tab - Excel 2007 | Excel Discussion (Misc queries) | |||
| What is missing from this form code? | Excel Programming | |||
| Apparently missing in Excel 2007 | Excel Discussion (Misc queries) | |||
| Missing VBA Code in Excel 2007 | Excel Programming | |||
Hybrid Mode
