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

[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.

 

[Steve Rindsberg]

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.

Look through the Options section of the registry entries for PowerPoint.
It'll probably be in that neighborhood:

HKEY_CURRENT_USER\Software\Microsoft\Office\X.0\PowerPoint\Options
(where X is the version number)

You can read the options settings but setting them won't help. PPT will
overwrite anything you change unless you make the changes when PPT isn't
running.

Any solutions you know of?

Sendkeys

Yeah. I know.

 

[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

 

[Steve Rindsberg]

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

Works in 2002 as well, btw.

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?

 

[Gregg]

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

 

[Steve Rindsberg]

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

If you did all that, you'd have made it on your own just fine. Might've taken
you a day or two longer is all.

Nice work!