Enable/activate toggle button with a macro

[RPM7]

I'm trying to create a macro to reset the information in my worksheet to its original settings/ cell values however I have two toggle buttons in the worksheet.

I thought I could just insert:

If ToggleButton1.Value = False Then
ToggleButton1.Value = True
End if

As you can see from my post, this obviously didn't work.
I've looked online but can't see this referenced anywhere.
Can anyone help? Thanks.

 

[MickG]

Hi, Why don't you use your coe to just disable the toggle buttons when you run the code. i.e. ".enabled = False", and have another code, perhaps when you open the sheet to "enable" them.
To my mind there are two ways to disable them , either by the ". enable" Method or to have some criteria at the start of the code that will run the code if met and not, if Not met.
As long as they don't work when you don't want them to, thats all that matters.
Regards Mick

 

[RPM7]

Hi Mick,

I suppose its just a silly little feature to have reset.
The spreadsheet (Calculator) could be in use all day. Plus its setup as a read only. For every new calculation we'd reset it back to the default values as that's whats used most of the time plus it means we don't have to check off the different items for a new calculation.

I'll leave it as it is. If they are enabled then, the fact they're highlighted red should get the user's attention. Thanks for all your help & sorry for putting ya to all the hassle.