Posted to microsoft.public.excel.worksheet.functions
|
|
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
|