ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Form Buttons Connected to a Macro - Want to remove the button (https://www.excelbanter.com/excel-worksheet-functions/146402-form-buttons-connected-macro-want-remove-button.html)

Wksht

Form Buttons Connected to a Macro - Want to remove the button
 
I have a form button that used to have a Go-To macro connected to it. I've
deleted the macro but the button remains. If I right click on it, it will not
highlight so I can delete it. Please advise.

Duke Carey

Form Buttons Connected to a Macro - Want to remove the button
 
right click in the toolbar area and select Visual Basic from the list of
toolbars available. On that toolbar select the icon with the triangle,
pencil, and ruler.

Now you should be able to select the button and delete it. Sometimes you
need to Ctrl-click to select

Then click on the triangle, pencil, ruler icon again


"Wksht" wrote:

I have a form button that used to have a Go-To macro connected to it. I've
deleted the macro but the button remains. If I right click on it, it will not
highlight so I can delete it. Please advise.


Wksht

Form Buttons Connected to a Macro - Want to remove the button
 
Thanks, that did it.

"Duke Carey" wrote:

right click in the toolbar area and select Visual Basic from the list of
toolbars available. On that toolbar select the icon with the triangle,
pencil, and ruler.

Now you should be able to select the button and delete it. Sometimes you
need to Ctrl-click to select

Then click on the triangle, pencil, ruler icon again


"Wksht" wrote:

I have a form button that used to have a Go-To macro connected to it. I've
deleted the macro but the button remains. If I right click on it, it will not
highlight so I can delete it. Please advise.



All times are GMT +1. The time now is 01:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com