C
Carmen
I have a "button" that I created and assigned a macro to. I no longer needed the macro or the button, so I deleted the macro but can not find ANY way to get rid of the button. Any help?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Harald Staff
Where is the button, and what kind of button is it ? What happens when you rightclick it ?
Best wishes Harald
"Carmen" <[email protected]> skrev i melding I have a "button" that I created and assigned a macro to. I no longer needed the macro or the button, so I deleted the macro but can not find ANY way to get rid of the button. Any help?
Best wishes Harald
"Carmen" <[email protected]> skrev i melding I have a "button" that I created and assigned a macro to. I no longer needed the macro or the button, so I deleted the macro but can not find ANY way to get rid of the button. Any help?
C
Carmen
The button (or maybe an "object" that I named and assigned the macro to) floats on top of cells on one of my worksheets. When I right-click on it, nothing happens and no pop-up menu appears. I also looked at all the commands /subcommands up top (file, edit, etc) and nothing is blackened to help (i.e. a delete). I can not drag the button around. If I delete the rows/columns where it floats, it just reappears in the same relative position of the new rows/columns.
?????
--
CARMEN HOVENDICK
Where is the button, and what kind of button is it ? What happens when you rightclick it ?
Best wishes Harald
"Carmen" <[email protected]> skrev i melding I have a "button" that I created and assigned a macro to. I no longer needed the macro or the button, so I deleted the macro but can not find ANY way to get rid of the button. Any help?
?????
--
CARMEN HOVENDICK
Where is the button, and what kind of button is it ? What happens when you rightclick it ?
Best wishes Harald
"Carmen" <[email protected]> skrev i melding I have a "button" that I created and assigned a macro to. I no longer needed the macro or the button, so I deleted the macro but can not find ANY way to get rid of the button. Any help?
B
Beege
Carmen
The Button....
Adding and modifying buttons can be done while in Tools/Customize menus. You
can right click the button then for your options, or just drag it off the
toolbar (or whereever)
Beege
I have a "button" that I created and assigned a macro to. I no longer
needed the macro or the button, so I deleted the macro but can not find ANY
way to get rid of the button. Any help?
The Button....
Adding and modifying buttons can be done while in Tools/Customize menus. You
can right click the button then for your options, or just drag it off the
toolbar (or whereever)
Beege
I have a "button" that I created and assigned a macro to. I no longer
needed the macro or the button, so I deleted the macro but can not find ANY
way to get rid of the button. Any help?
B
Beege
Harald knows his stuff, asking the right questions...
Try Edit/GoTo/Special/Objects
Delete.
Is your sheet protected?
Beege
The button (or maybe an "object" that I named and assigned the macro to)
floats on top of cells on one of my worksheets. When I right-click on it,
nothing happens and no pop-up menu appears. I also looked at all the
commands /subcommands up top (file, edit, etc) and nothing is blackened to
help (i.e. a delete). I can not drag the button around. If I delete the
rows/columns where it floats, it just reappears in the same relative
position of the new rows/columns.
?????
--
CARMEN HOVENDICK
Where is the button, and what kind of button is it ? What happens when you
rightclick it ?
Best wishes Harald
"Carmen" <[email protected]> skrev i melding
I have a "button" that I created and assigned a macro to. I no longer
needed the macro or the button, so I deleted the macro but can not find ANY
way to get rid of the button. Any help?
Try Edit/GoTo/Special/Objects
Delete.
Is your sheet protected?
Beege
The button (or maybe an "object" that I named and assigned the macro to)
floats on top of cells on one of my worksheets. When I right-click on it,
nothing happens and no pop-up menu appears. I also looked at all the
commands /subcommands up top (file, edit, etc) and nothing is blackened to
help (i.e. a delete). I can not drag the button around. If I delete the
rows/columns where it floats, it just reappears in the same relative
position of the new rows/columns.
?????
--
CARMEN HOVENDICK
Where is the button, and what kind of button is it ? What happens when you
rightclick it ?
Best wishes Harald
"Carmen" <[email protected]> skrev i melding
I have a "button" that I created and assigned a macro to. I no longer
needed the macro or the button, so I deleted the macro but can not find ANY
way to get rid of the button. Any help?
C
Carmen
Beege, I went to tools/customize as you suggested and then tried to right
click the button on my worksheet (not toolbar),nothing, then tried to drag
it and nothing, Thanks but this did not work.
click the button on my worksheet (not toolbar),nothing, then tried to drag
it and nothing, Thanks but this did not work.
G
Gord Dibben
Carmen
Bring up the Control Box Toolbar by right-click on a toolbar and select.
Hit the Design Mode Icon.
You should now be able to right-click on the "button" and Edit>Clear>All
Close the Control Box Toolbar.
Gord Dibben MS Excel MVP
Bring up the Control Box Toolbar by right-click on a toolbar and select.
Hit the Design Mode Icon.
You should now be able to right-click on the "button" and Edit>Clear>All
Close the Control Box Toolbar.
Gord Dibben MS Excel MVP
C
Carmen
Beege, I tried Edit/GoTo/Special/Objects while in the worksheet where the
button/object is and it said it could not find any objects. Not sure
whether the sheet is protected, how do you tell (or do I need to know if the
try above found no objects?)?
Thanks but any more suggestions?
button/object is and it said it could not find any objects. Not sure
whether the sheet is protected, how do you tell (or do I need to know if the
try above found no objects?)?
Thanks but any more suggestions?
C
Carmen
Gord, you are a genius, that did the trick. Thanks.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.