Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 VB Controls Backwards Compatibility
I have created a spreadsheet in Excel07 with a few simple controls. In VB, I
created several buttons, most of which run a simple save / email command. Some of my coworkers still run Excel 2003. When they open the spreadsheet, the controls have no function at all. I have saved the file in several different ways. it originated as a xlsm (macro enabled excel file). When that wouldn't work on their 03 machines, I saved the file as a 97-2003xls file. This allowed them to open the file, but no buttons worked. On their machine, I edit security settings to allow all macros, etc. This is causing a fatal error when the open the file. So I'm stuck. How can I make my VB controls operate properly on a 2003 machine? Any help would be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 VB Controls Backwards Compatibility
Are you talking about Ribbon Controls in 2007? If so, I don't believe you
can use them in 2003. There is other functionality you'll need to use and I've never used it, so can't give you any more ideas. Maybe someone else can. Barb Reinhardt "wdtanner" wrote: I have created a spreadsheet in Excel07 with a few simple controls. In VB, I created several buttons, most of which run a simple save / email command. Some of my coworkers still run Excel 2003. When they open the spreadsheet, the controls have no function at all. I have saved the file in several different ways. it originated as a xlsm (macro enabled excel file). When that wouldn't work on their 03 machines, I saved the file as a 97-2003xls file. This allowed them to open the file, but no buttons worked. On their machine, I edit security settings to allow all macros, etc. This is causing a fatal error when the open the file. So I'm stuck. How can I make my VB controls operate properly on a 2003 machine? Any help would be appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 VB Controls Backwards Compatibility
Form controls on the worksheet itself. A button, coded in VB, that saves the
form then opens outlook, attaches the worksheet to an email, adds subject, precipitants, etc. "Barb Reinhardt" wrote: Are you talking about Ribbon Controls in 2007? If so, I don't believe you can use them in 2003. There is other functionality you'll need to use and I've never used it, so can't give you any more ideas. Maybe someone else can. Barb Reinhardt |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 VB Controls Backwards Compatibility
When you open the workbook in 2003, do it with the SHIFT key down (or don't
enable the macros). Then compile the code to see what the issue might be. "wdtanner" wrote: Form controls on the worksheet itself. A button, coded in VB, that saves the form then opens outlook, attaches the worksheet to an email, adds subject, precipitants, etc. "Barb Reinhardt" wrote: Are you talking about Ribbon Controls in 2007? If so, I don't believe you can use them in 2003. There is other functionality you'll need to use and I've never used it, so can't give you any more ideas. Maybe someone else can. Barb Reinhardt |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 VB Controls Backwards Compatibility
A rule of thumb is that if your workbook will be opened by users of
various versions of Excel, you should create it in the oldest version on which it will be opened. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ wdtanner wrote: I have created a spreadsheet in Excel07 with a few simple controls. In VB, I created several buttons, most of which run a simple save / email command. Some of my coworkers still run Excel 2003. When they open the spreadsheet, the controls have no function at all. I have saved the file in several different ways. it originated as a xlsm (macro enabled excel file). When that wouldn't work on their 03 machines, I saved the file as a 97-2003xls file. This allowed them to open the file, but no buttons worked. On their machine, I edit security settings to allow all macros, etc. This is causing a fatal error when the open the file. So I'm stuck. How can I make my VB controls operate properly on a 2003 machine? Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting backwards compatibility question | Excel Worksheet Functions | |||
Backwards Compatibility with Excel 2002 | Excel Discussion (Misc queries) | |||
Excel 2007 backwards compatibility - nesting functions | Excel Worksheet Functions | |||
Backwards-compatibility problem with OpenText | Excel Programming | |||
backwards compatibility for Excel 2007 | Excel Discussion (Misc queries) |