Running Excel 4.0 Macro in Excel 2007.

[CdSlc]

I am a rookie in Excel macros. I am just taking over an application that was
developed in Excel 4.0 macro ages ago and the company does not have the time
or resources to re-code the whole thing in VBA. But they want the same Excel
4.0 macro application to run in Office 2007.

This 4.0 macro runs commands like "=DELETE.COMMAND(CBBar,5,4,1)" which in a
pre-Excel 2007 setup, used to delete the "Format - Sheet - Rename" option.
Later in the code it goes ahead and adds its own macro for this "Format -
Sheet - Rename" option. As I understand, the "5, 4, 1" in the command
indicated to select the fifth menu from left, four menu down and first menu,
which happens to be "Format (5) - Sheet (4) - Rename (1)" option.

With Excel 2007 ribbon style, the Sheet Rename option is no longer at this
position. So, what is the kind of equivalent by which I can achieve this same
functionality in Excel 2007? Any suggestion to resolve this issue would be
highly appreciated.

Did lots of googling and did not find anything helpful between Excel 4.0
macro and Excel 2007. Any helpful links in this direction would also be
highly appreciated.

Thanks.

 

[Jim Rech]

There is nothing equivalent in Excel 2007 because ribbon command disabling
is no longer done with code. It's done with RibbonX the variant of XML that
customizes the ribbon. The RibbonX is embedded into the Excel 2007 file.
If you're new to Excel macros you really have a lot to chew on.<g>

http://www.rondebruin.nl/ribbon.htm
http://msdn2.microsoft.com/en-us/library/aa338202.aspx

--
Jim
|I am a rookie in Excel macros. I am just taking over an application that
was
| developed in Excel 4.0 macro ages ago and the company does not have the
time
| or resources to re-code the whole thing in VBA. But they want the same
Excel
| 4.0 macro application to run in Office 2007.
|
| This 4.0 macro runs commands like "=DELETE.COMMAND(CBBar,5,4,1)" which in
a
| pre-Excel 2007 setup, used to delete the "Format - Sheet - Rename" option.
| Later in the code it goes ahead and adds its own macro for this "Format -
| Sheet - Rename" option. As I understand, the "5, 4, 1" in the command
| indicated to select the fifth menu from left, four menu down and first
menu,
| which happens to be "Format (5) - Sheet (4) - Rename (1)" option.
|
| With Excel 2007 ribbon style, the Sheet Rename option is no longer at this
| position. So, what is the kind of equivalent by which I can achieve this
same
| functionality in Excel 2007? Any suggestion to resolve this issue would be
| highly appreciated.
|
| Did lots of googling and did not find anything helpful between Excel 4.0
| macro and Excel 2007. Any helpful links in this direction would also be
| highly appreciated.
|
| Thanks.