Hi all,
I have a toggle button (named 'toggle') on a worksheet to turn a function on and off (this all works fine). However, I need to always have the toggle button 'on' when the workbook is opened, and it is currently not working correctly.
I have 'Sheets("Sheet 1").toggle.Value = True' (not text True) in a Workbook_Open() event, and this is setting the linked cell to True on the workbook opening.
However, the toggle button isn't 'depressing' to show the user the function is turned on?? But the function is still on and working fine??
So I need to know how to make the button turn on, but also depress to show it's 'clicked on'. Can anyone help please?
In addition, is there anyway to change the words on the toggle button to 'On' or 'Off', depending whether the button is pressed down or not? This is just a secondary question, would be great if anyone has an answer to this but it's not important :-)
Thanks all,
Nat :-)
Bookmarks