right-click on a control button and view code does nothing

K

Kate

I'm trying to find out what macro a button is running. I have the sheet
unprotected and design mode on but right-click does nothing and double-click
still runs the macro. Do I have an option set wrong or something?
 
C

Chip Pearson

Are you sure the button is form the Controls command bar not the Forms
command bar?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
K

Kate

I'm not sure what kind of button it is. Is there a different method for
viewing what is being done by a forms button? All I know is that it runs a
macro but I can't figure out which one.
 
D

Dave Peterson

When you rightclick on the button, do you see an option for Assign Macro?

If yes, what do you see when you click on that option?
 
K

Kate

Right click on the button does absolutely nothing. It's like right-click
isn't enabled but I'm not sure how to check it.
 
D

Dave Peterson

Is the workbook shared?
Is the worksheet protected?
Is the project protected?
 
P

Peo Sjoblom

Click view>toolbars>control toolbox, then click the triangular ruler to get
into design mode, now select and right click the button, do you get a menu
now?


--


Regards,


Peo Sjoblom


Kate said:
no
no
no
Click to expand...
 
K

Kate

nope. I do that and nothing happens.

Peo Sjoblom said:
Click view>toolbars>control toolbox, then click the triangular ruler to get
into design mode, now select and right click the button, do you get a menu
now?


--


Regards,


Peo Sjoblom
Click to expand...
 
D

Dorothy

me too...thank you for the effort






- Show quoted text -
Click to expand...

Depending on how complicated the spreadsheet is, you can view all the
macros by right clicking on the tab name and choosing "View Code".
This will pull up all the macros associated with that particular tab.
This would be a last resort thing since if there are a lot of macros
associated with that tab, it could be hard to find the macro specific
to that button. If you're lucky, whoever wrote it, would have named
it with something to give you a clue as to what function it performs
when it's run and you might be able to locate the macro.

Good luck!

Dorothy
 
Top