ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to disable form buttons using macro? (https://www.excelbanter.com/excel-programming/290832-how-disable-form-buttons-using-macro.html)

shirley

how to disable form buttons using macro?
 
what is the syntax to disable a button during startup

--
Message posted from http://www.ExcelForum.com


Bob Phillips[_6_]

how to disable form buttons using macro?
 
You could hide it

activesheet.shapes("Button 1").visible=false

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"shirley " wrote in message
...
what is the syntax to disable a button during startup?


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 01:43 PM.

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