Compile Error:Sub or Function not defined

[protect02476]

I tried converting an excel 2003 wb to 2007 and recieved this error message when clicking one of the macro enabled comboboxes in the wb:

Compile error: Sub or Fuction not defined

Private Sub Combobox2_Change()
Call include_logo (Combobox2.Value)
End Sub

I didn't write the VBA code so I will not be able to help much in answering any technical questions. I'd be willing to send the file to you for examination. Can anyone help? Thanks in advance!

 

[RoryA]

What it means is that you do not have a routine called include_logo in your workbook.

 

[protect02476]

Hi Rorya,

Thanks for the reply.

However, the routine works in excel 2003. It somehow goes missing aftering converting to 2007.

 

[RoryA]

Did you just do a File-Save As and then choose xlsm?

 

[protect02476]

No, I opened the file, hit convert and then saved. I let excel do it all.

 

[RoryA]

Hit what Convert? If you open a 2003 file in 2007, it should just open it, not try and convert it.

 

[protect02476]

well, I want to use a 2003 file with 2007. I thought that was the proper way to handle a 2003 file in 2007, guess I'm confused. Aren't some macros disabled when opening a 2003 file in 2007?

 

[RoryA]

No. In 2007 any file containing macros is treated the same, depending on your security settings. What is this Convert option you mention?

 

[protect02476]

In 2007 if the file was created in an older version of excel there is a convert option in the main drop down menu for conevrting the file to a maco-enabled workbook (*.xlms).

 

[RoryA]

Ah, OK - I thought you were talking about an automatic prompt when you opened the file. That should work though. If I PM you an email address, can you send me the 2007 version?