Solved

Word Doc opening in design mode. Please make it stop!!

Posted on 2006-11-05
4
3,254 Views
Last Modified: 2011-08-18
I have inherited a Word Doc that I've converted into a survey form. It was originally made to be printed so it had pictures of radio buttons vs real ones. I replaced all of the pictures with actual radio buttons from the toolbox. I want the document to open so that the user cannot edit any of the questions and only allow them to check the radio buttons. At the moment, each time I open the document, it opens in design mode. I've tried to open the Forms toolbar and lock the document, but that secured everything and you can't click on anything. I've tried to disable the Edit menu using code, but it still hasn't fixed my problem.

I want to try to avoid using passwords. I want the document to open normally (not in edit mode) and only allow my users to click the radio buttons and save.

Any help is GREATLY appreciated.
J
0
Comment
Question by:jefftwilley
  • 2
  • 2
4 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 17877316
Design mode? It's not quite clear what you mean by that.

There are two type of controls that can be placed on documents, form field controls and ActiveX controls. The latter can also be placed on VBA UserForms. Usually, you only 'lock' a document, i.e. Protect it for Forms use, if you are using Forms controls. These controls to enter text into a Forms text input fiel, selecting from Forms dropdowns or checking Forms checkboxes -  to display or not display an X.

You are using radio buttons, which are not implemented in form field controls, so I suppose that you are not using form fields. However, if you do protect a document so, you should still be able to use the ActiveX controls. Is that not your experience?

0
 
LVL 34

Author Comment

by:jefftwilley
ID: 17877401
No, that doesn't happen. Try creating a document...nothing fancy. Add a paragraph or some lines of text. Then open the Control ToolBox. Drag a radio button over and drop it on the document. If you protect the document now...then you can't click the radio button. Take the protection off, and of course you can then edit the paragraph or text.

If you don't enable macros, the document opens in "Edit" mode. Meaning, that stupid little green triangle is pressed and you can edit the object.

I can do this using the On_open event

  If CommandBars("Control Toolbox").Visible = True Then
  ActiveDocument.ToggleFormsDesign
  End If

But if the user doesn't enable macros...then it doesn't run.

Got anything else?

It can't be read only. The user must be able to open it and complete the survey, save it so it can be e-mailed back. So passwording the form as read only won't work either. I can't change it to a PDF, I can't make it a web doc.
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 17877769
Hmm.

That's not quite my experience. Obviously if there is only one Option(radio) button, then clicking on it isn't going to do very much. I have just added two radio buttons, left their group name as default - presumably a zero-length string ("") and protected the document for forms with the padlock-iconned button on the forms toolbar. I can happily switch between the two, setting each when I do so.

I see that you mention 'enabling macros'. ActiveX controls are essentially controls for VBA. If macros aren't enabled, then they are virtually worthless.
0
 
LVL 34

Author Comment

by:jefftwilley
ID: 17877827
I have 33 questions, each with anywhere from 1 to 5 options per question. They are grouped by name so that they work as an option group. I have automation that I'm using in a Access database to harvest the values of these...that all works perfect. But what I'm finding is that if I protect the document, and don't enable macros, the radio buttons don't function. So it is as you said I guess. I just wanted to make sure I was doing all I could to protect the document. I can't force 150 surveyees to enable macros....so I guess that's another problem. Thanks for confirming what I had found. I appreciate your input.
J
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now