| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
right-click on a control button and view code does nothing
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right-click on a control button and view code does nothing
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right-click on a control button and view code does nothing
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right-click on a control button and view code does nothing
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right-click on a control button and view code does nothing
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right-click on a control button and view code does nothing
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right-click on a control button and view code does nothing
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right-click on a control button and view code does nothing
I'm out of guesses based on the info you've provided.
Kate wrote: 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 -- Dave Peterson |
|
#10
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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right-click on a control button and view code does nothing
me too...thank you for the effort
"Dave Peterson" wrote: I'm out of guesses based on the info you've provided. Kate wrote: 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 -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
right-click on a control button and view code does nothing
On Nov 15, 3:35 pm, Kate wrote:
me too...thank you for the effort "Dave Peterson" wrote: I'm out of guesses based on the info you've provided. Kate wrote: 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 -- Dave Peterson- Hide quoted text - - Show quoted text - 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Click on chart to view it otherwise greyed out | Charts and Charting in Excel | |||
| Control plus click will not select multiple boxes | Excel Worksheet Functions | |||
| is there a control 2 increase a number in a cell by click on the c | Excel Discussion (Misc queries) | |||
| call a function on control click event | Excel Discussion (Misc queries) | |||
| Control toolbox Buttons disappear on click | Excel Discussion (Misc queries) | |||
Linear Mode
