Odd behavior when Command Buttons are present.

macropod · #1 05-02-2019, 09:39 PM

Cross-posted at: http://www.vbaexpress.com/forum/show...ns-are-present
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

RaudelJr · #2 05-02-2019, 09:58 PM

Quote:

Originally Posted by macropod

Cross-posted at: http://www.vbaexpress.com/forum/show...ns-are-present
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Sorry about that.

I did post here first, then later in the vbaexpress forum.
I mentioned my cross posting in the first line of my post there, though the site didn't let me post URL strings.

I didn't want to cross post. But I have this document due tomorrow, and I've spend hours researching.

I might end up having to do a workaround.

Any help is appreciated.

Thanks in advance macropod

RaudelJr · #3 05-03-2019, 12:42 AM

I have created a step by step as suggested by Cindy Meister at https://stackoverflow.com/questions/...65262#55965262

I hope you are successful at creating a Macro enabled document that has a working Macro first, but then stops working with the insertion of a Button. Instructions below.

--------------------
Open a Word Document

Create a and enter the following code:

Code:

    Sub UpdateOptions()
    Dim bProtected As Boolean
    'Unprotect the file
    If ActiveDocument.ProtectionType <> wdNoProtection Then
        bProtected = True
        ActiveDocument.Unprotect Password:=""
    End If

    Select Case ActiveDocument.FormFields("Bookmark0").Result
        Case "Bookmark1"
            ActiveDocument.Bookmarks("Bookmark1").Select
            SendKeys "%{down}"  'Displays choices in drop-down field
        Case "Bookmark2"
            ActiveDocument.Bookmarks("Bookmark2").Select
            SendKeys "%{down}"  'Displays choices in drop-down field
        Case "Bookmark3"
            ActiveDocument.Bookmarks("Bookmark3").Select
            SendKeys "%{down}"  'Displays choices in drop-down field
    End Select
    If bProtected = True Then
        ActiveDocument.Protect _
            Type:=wdAllowOnlyFormFields, _
            NoReset:=True, _
            Password:=""
    End If
End Sub

-----------------
On Word Document

Type Bookmark0
Insert a Legacy Drop down Form Field
List: Bookmark1, Bookmark2, Bookmark3
Bookmark: Bookmark0
Run Macro on Exit: UpdateOptions

Enter
Enter
Type Bookmark1
Insert a second Legacy Drop down Form Field
List: 1, 2, 3.
Bookmark: Bookmark1

Enter
Enter
Type Bookmark 2
Insert a third Legacy Drop down Form Field
List: 1, 2, 3.
Bookmark: Bookmark2

Enter
Enter
Type Bookmark3
Insert a fourth Legacy Drop down Form Field
List: 1, 2, 3.
Bookmark: Bookmark3

Your document should look like this at this point:

Bookmark0[dropdown]

Bookmark1[dropdown]

Bookmark2[dropdown]

Bookmark3[dropdown]

Save document as a Macro Enabled document.

Lock document

Testing:
- Change the first drowpdown options only from the available listed options (Bookmark1, Bookmark2, Bookmark3)
- Everytime you change your selection you will be directed to the corresponding Bookmark Dropdown Form Field.
- Should be working as expected.

Next, Button conflict

Unlock document
Insert a Button at the end of the document below Bookmark3
[Button]

Your document should look like the same as above but with a button now:

Bookmark0[dropdown]

Bookmark1[dropdown]

Bookmark2[dropdown]

Bookmark3[dropdown]

[Button]

Lock document

Testing Button conflict:
- Change Bookmak0 selection from (Bookmark1, Bookmark2, Bookmark3)
- Everytime you change your selection you will NOT be directed to the corresponding Bookmark Dropdown Form Field.
- Everytime you change your selection you will be directed to a field after the intended corresponding Bookmark Dropdown Form Field.
- Macro is not working as expected with the presence of a Button.
- Unlock document, delete the button, lock document, it will be working fine again.

Please let me know if you have any questions.

Thank you for any help in advance.

Raudel

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hiding Command Buttons before PDF	ksigcajun	Word VBA	3	05-07-2014 05:31 AM
Command buttons on slidemaster	chcope	PowerPoint	2	06-13-2013 04:30 PM
Command Buttons	lorenambrose	Word	0	10-06-2011 11:55 AM
command buttons	ronf	Excel	0	04-28-2006 08:32 AM
command buttons	ronf	Excel	0	12-03-2005 06:26 AM