Storing A Variable on Close

[poleary2000]

I have code that runs upon opening. The code opens a UserForm that asks the user a question. I would like to have an option to turn the UserForm on or off WITHOUT storing a value in a worksheet. I guess I would like to have a check box like to have a check box on the UserForm that asks the user if they would like to see the form on Startup. Can this be done?

 

[Legacy 98055]

I tested it
Found this error

If Err.num = 53 Then

Should be

If Err.Number = 53 Then

Besides that it works

Tom

 

[poleary2000]

Wow - yes it does work. However, will it work if I have the file in one directory, click the box, save, close, move the file and open again.

If not, I would rather try the name method suggested above [the code makes more sense to me].

 

[poleary2000]

Tom,

How can I turn the form back on? For some reason I am having trouble with that.

 

[poleary2000]

Got it

 

[Legacy 98055]

Hi
If you want the form to show when the workbook is moved:

In Sub CheckFileSwitch()

Change:

Open Application.Path & "/noopen" For Input As #1

To:

Open ActiveWorkbook.Path & "/noopen" For Input As #1

In Sub CheckBox1_Click()

Change:

Open Application.Path & "/noopen" For Output As #1

To:

Open ActiveWorkbook.Path & "/noopen" For Output As #1

Hope this helps,
Tom

 

[poleary2000]

Thanks Tom!