Solved

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

Posted on 2006-11-05
4
3,255 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction Authors who set out to write any sort of lengthy piece for online submission—be it a long question or comment on a technical form, an article, or a substantial blog entry—often find it useful to work up a draft in an editor other t…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…

920 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

15 Experts available now in Live!

Get 1:1 Help Now