View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default right-click on a control button and view code does nothing

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