disable button

Good morning, I am using a button to move end of day balances to beginning of day and clear out data. If the button is clicked twice it will move 0's to the beginning balances. I am trying to prevent this from happening. I want the button to only be clicked once until the file has been saved...

Hi everyone.i have a drop down list with validation data.it cant be locked because user cant select from the list,and since it is unlocked user can delete the contents of the selection cell by del key on keyboard.How can i prevent this issue.Your help would be highly appreciated.

I have part of a sub that captures a Button click, and then runs a processes. I want to disable the Button if the count in a cell = 0 (see red line in code) and enable it again when the sub is evoked again. Here's what I have: b???Enabled = True 'This is here to enable the Button when the sub...

Hello ALL, I have searched all over the various threads but I did not find anything that resembles my issue. I have created a Workbook that uses a macro to create additional worksheets. The macro is activated by a button. What I would like to do is make sure that the user will not be able to...