Solved Is there a way to 'test' if compact on close is on or off via VBA? (1 Viewer)

[gojets1721]

Bit of an odd question...I know you can set 'compact on close' on or off via VBA by utilizing Application.SetOption "Auto compact", True or Application.SetOption "Auto compact", False.

Is there a way in VBA to essentially test if 'compact on close' is on or off?

I.e. something like this:

If Application.SetOption "Auto compact" is True Then
'do something'
Else
'do something else'
End IF

Obviously this errors out on the first line but I'm not sure how to restructure it to get it to work, or if its even workable at all.

Thanks!

 

[Josef P.]

If Application.GetOption("Auto compact") then
...

 

[gojets1721]

If Application.GetOption("Auto compact") then
...

Thank you!