How do I initialize Toggle Button Value when opening workbook?

[sauerj]

When opening a workbook, I'd like to set a Toggle Button's value to TRUE. I already have code Workbook_Open() procedure which resides in the ThisWorkbook module. This Workbook_Open() procedure already does lots of other things. I would like to add code in Workbook_Open() that would set the Toggle Button's initial value (TRUE). The code for the Toggle Button resides in one of the Sheet modules (not the ThisWorkbook module). I attempted to set this toggle button value using the following code (see row 10), but it does not pass the compiler due to not being a defined variable. I am unable to find any HELP on the internet. Can you help me?

Please Login or Register  to view this content.

Below, I have added the code for the Toggle Button itself (for its CLICK event). I want to set (or initialize) the value of this Toggle Button to TRUE when the workbook is opened. And, hopefully do this within the Workbook_Open procedure.

Please Login or Register  to view this content.

[pike]

Hi sauerj
It depends

Please Login or Register  to view this content.

what do you have or

Please Login or Register  to view this content.

[royUK]

Just add thisline to the Open event,make sure the sheet & button nams are changed to the correct ones for your workbook

Please Login or Register  to view this content.

[sauerj]

It worked great! Thanks! Amazing what ONE word will do. I will marked it as SOLVED. Thanks again!