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.