View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kate kate is offline
external usenet poster
 
Posts: 112
Default right-click on a control button and view code does nothing

nope. I do that and nothing happens.

"Peo Sjoblom" wrote:

Click viewtoolbarscontrol 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" wrote in message
...
no
no
no

"Dave Peterson" wrote:

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



Kate wrote:

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.

"Dave Peterson" wrote:

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?

Kate wrote:

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.

"Chip Pearson" wrote:

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)


"Kate" wrote in message
...
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?


--

Dave Peterson


--

Dave Peterson