VBA code to check/change for AutoCorrect - Automatic Layout...?

G

Gregg

Hello, again. I'm stuck, once more.

I can't find a way for my code to check the machine's AutoCorrect
setting for Automatic Layout for Inserted Objects. I want it to first
note if it's enabled and then disable it. So, two actions there.

Any solutions you know of?

As always, I greatly appreciate your help.
 
G

Gregg

Hey! <big smile of elation> I think it turned out to be easier than I
thought. I threw this together and it seems to work for me. Can you
check it out?

Sub OptionCheck()
If Application.AutoCorrect.DisplayAutoLayoutOptions = False Then
MsgBox "The option is turned OFF."
ElseIf Application.AutoCorrect.DisplayAutoLayoutOptions Then
MsgBox "That #!%&#! option is turned ON and off it goes!"
Application.AutoCorrect.DisplayAutoLayoutOptions = False
End If
End Sub
 
G

Gregg

Steve said:
That (or the reg entry) should help you get PPT setup for your users, but
unfortunately, it won't do any good when they (or your code) runs into
presentations that the wrong setting has already caused to be munged.

But I think you've got that sorted too, right?

You bet. All my thoughts posted here (and yours) went into the same pot
of tea. My routine incorporates a dozen looks at their slide and
options to make sure the graphic is the correct graphic and that it
gets manipulated to the right size and position. It has about a half a
ton of ID-10-T checks. <g> It even pauses to allow the user to move the
picture inside a cropping frame. Then they hit CROP in the modeless
userform to trim it. It's pretty wild. It was a lot of work and my
brain is still steaming, but it was worth it.

And I couldn't have done it without your help. Thanks a whole lot!

-Gregg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top