Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True Me.Hide End If End Sub
How do you revise the above code to keep the current changes after exiting or closing Excel.
This is what is currently happening with this code and my toggle buttons
1. I push the toggle buttons "in"
2. I save my changes
3. I close the spreadsheet
4. I reopen the spreadsheet
5. The toggle buttons are in the "out" position
6. It does not recognize my previous change.
I do I fix this problem. I really need this to save(remember) my toggle buttons in the position that I "set" each time I go in and out of the spreadsheet.