I have created a button (using the
VB toolbox) in a 2003 version of excel. I
then saved the workbook and opened it up in excel 2007. When I click on the
button it runs through the macro behind it. However when I right click on
the button there is no functionality and so I can't see the code behind it.
I have other macros written in 2007 and I can access them but not the 2003.
So how can I view my original macro? Is there any way to view the Visual
Basic Tool Bar in Excel 2007?
TIA
--
Lyndsey Wood
www.totalsolutionmapping.com