View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
megabite megabite is offline
external usenet poster
 
Posts: 7
Default 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?