ExcelBanter - Remove Forms Command Button

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Remove Forms Command Button (https://www.excelbanter.com/excel-programming/407895-remove-forms-command-button.html)

Karen53

Remove Forms Command Button

Hi,

Is there a way to totally remove a forms toolbox command button from a
spreadsheet with VBA?
--
Thanks for your help.
Karen53

Mike H

Remove Forms Command Button

Hi,

Try this

ActiveSheet.Shapes("Button 1").Delete

Mike

"Karen53" wrote:

Hi,

Is there a way to totally remove a forms toolbox command button from a
spreadsheet with VBA?
--
Thanks for your help.
Karen53

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