Saving change in Property (Help)

dave8

Active Member
Joined
Jul 8, 2007
Messages
275
This is very simple, but I can't get it to work. I have a userform that contains two checkboxes. If the user clicks on one checkbox, I want to save this property so that the next time the workbook launches, it will not display the form. For example, when checkbox1 value is true, I save the workbook using ThisWorkbook.save. This doesn't work. So, how do I save the workbook when the property value of the checkbox changes?
 
Yes, I think this will work, but you gave me another idea. When the value of the checkbox is True, I will put a "1" located somewhere hidden on a worksheet. The 'Thisworkbook.save' will work in this case. When the workbook is open the next time around, I will check for this value at the specified location. If the value exist, I know not to display the form.
 
Upvote 0

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,215,632
Messages
6,125,909
Members
449,274
Latest member
mrcsbenson

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top