Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / October 2006

Tip: Looking for answers? Try searching our database.

Exit design mode again

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bztips - 10 Oct 2006 14:34 GMT
I know similar questions have been asked a thousand times, but here
goes...

I have a main document to be mail-merged; it has some form fields (drop
down boxes) for the user to enter information. It also has a pushbutton
I created from the Control Toolbox. I save the document as Unprotected
in order to do the mail merge. When the end user opens the document,
there is an Autoopen() macro that turns on Protection.

When a user tries to use this file on another machine, it opens fine.
But he gets the dreaded "Can't exit design mode because Control xxx
cannot be created" when he clicks the pushbutton.

Ideas?

Thx.
/Bill
Jay Freedman - 10 Oct 2006 15:11 GMT
Yes, the idea is to get rid of the pushbutton. The ActiveX controls from the
Control Toolbox have many problems, ranging from "Control xxx cannot be
created" to just opening in design mode because macros are disabled by the
security mechanism. I can't recommend them for any use. However, you might
read
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnword2k2/html/
odc_activeX.asp
.

Try using a MacroButton field and a macro instead. MacroButton fields do
work in protected forms -- see
http://www.word.mvps.org/FAQs/TblsFldsFms/HLinksInForms.htm for an example.
With a little clever formatting, you can even make a MacroButton field look
like a pushbutton.

Signature

Regards,
Jay Freedman
Microsoft Word MVP        FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> I know similar questions have been asked a thousand times, but here
> goes...
[quoted text clipped - 13 lines]
> Thx.
> /Bill
bztips - 10 Oct 2006 16:01 GMT
OK, I tried using a MacroButton

{ MACROBUTTON UpdateTotal Update }

where UpdateTotal is a subroutine defined in Module1 of the document.

Supposedly UpdateTotal should execute when I double-click the button.
But I can't even get to the second click -- after the first click, the
focus is moved to another location in the document. Needless to say,
the subroutine never fires.

/Bill

> Yes, the idea is to get rid of the pushbutton. The ActiveX controls from the
> Control Toolbox have many problems, ranging from "Control xxx cannot be
[quoted text clipped - 33 lines]
> > Thx.
> > /Bill
bztips - 10 Oct 2006 17:42 GMT
OK, Jay, I found your answer to this question from one of your previous
posts (in 2003!) Thx.

> OK, I tried using a MacroButton
>
[quoted text clipped - 46 lines]
> > > Thx.
> > > /Bill
Jay Freedman - 11 Oct 2006 00:53 GMT
Glad I could help, even retroactively. :-)  I assume you found the
part about Options.ButtonFieldClicks = 1.

--
Regards,
Jay Freedman
Microsoft Word MVP        FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

>OK, Jay, I found your answer to this question from one of your previous
>posts (in 2003!) Thx.
[quoted text clipped - 49 lines]
>> > > Thx.
>> > > /Bill
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.