Cannot see macro behind button?

[Kimberly Anne]

I have inherited a workbook from a previous employee that has a few
buttons that start macros when pushed. In the past, I've always been
able to right-click on a button and assign it a macro. With this
workbook, nothing happens if you right-click on the buttons (the font
on the button changes a bit, but that's it). Any idea how I can get
around this and see what macro is assigned to each button? (I'd like
to make the sheet a bit more user-friendly, and it would be much easier
if I could just re-assign the macros instead of creating a whole new
sheet.)

Thanks!
Kim

 

[Peo Sjoblom]

View>toolbars>control toolbox, click one the triangular ruler to get into
design mode, now right click and select view code
When you are done click on the ruler again to get out of design mode
I am guessing that the buttons come from the control toolbox since nothing
happens when you right click it,
those from the forms toolbar behave like you are used to with the assign
macro option

The forms toolbar are from earlier excel versions (pre 97) and the control
toolbox is much more powerful


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)