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