VBA disable command button permanently

Hi.
You invite each to draw shapes and play around with the buttons?
Show an example in the file.

Hi polazzopardi,
Welcome to the forum.

One way is to flag a cell on any sheet and check that cell value during the UserForm Initialize event and if the flag is found set the enable property of the button to false.

In the below code when the UserForm initializes first time it doesn't find the text "Disable" in the cell AAA1 on Sheet1 and once the Start_btn is clicked the button click event places the text "Disable" in the cell AAA1 on Sheet1 and next time when you open the UserForm the Form Initialize event find the text "Disable" in cell AAA1 on Sheet1 and it sets the Enable property of the Start_btn to False and hence the Start-btn is permanently disabled.

Please Login or Register  to view this content.

See if this helps.

You're welcome Paul! Glad your issue is resolved.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

You may also say thanks to those who have put their time and efforts to help you in this forum by clicking the Add Reputation link under their posts, another way to say thanks.