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 / February 2005

Tip: Looking for answers? Try searching our database.

Stuck in Design Mode - Please Help!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
singeredel - 25 Feb 2005 18:16 GMT
I created a project with a userform and code and another module in same
project. Now when I access the project through the VB Editor, the design mode
button is highlighted, However, when I try to disable the design mode, it
tells me the macros in this project are disabled. The template has a digital
certificate assigned and "trust all add-ins and templates" and "trust access
to visual basic project" are selected. In addition, the template is loaded
and checked under "templates and add-ins."  What is the problem? I cannot
access any of my macros!
Signature

singeredel

David - 25 Feb 2005 20:32 GMT
> when I try to disable the design mode,
  ?????????????

Make sure you save document, and File->close or click X in corner of
editor.

On running the macro,

Tools->Macros->Security->Low or Medium, perhaps.

Close document, reopen then Tools->Macros->projectname
singeredel - 25 Feb 2005 23:45 GMT
I am not sure what you are telling me -- that I have to run the programs with
low or medium security? If so, that defeats the purpose of assigning digital
certificates -- so that I can have my security at a higher level.

I have tried everything. Two of my projects, one of them that contains many
of my macros for running userforms and other macros in other projects, always
opens with the design mode button highlighted in the VB Editor. One of these
templates has a Digital Certificate assigned. The other project only contains
modules and has no Active-X controls. When I try to click on this design mode
button to turn off design mode in either of these projects, I get a "macros
in this project are disabled" -- The only way I can run these programs is
with security set to low.

> > when I try to disable the design mode,
>    ?????????????
[quoted text clipped - 7 lines]
>
> Close document, reopen then Tools->Macros->projectname
singeredel - 26 Feb 2005 00:39 GMT
I have since narrowed it down to one offending Project by deleting all the
references in my MacroReports project that contains the macros for running
other projects and then one by one adding the references to these other
projects back in. There was only one project that caused the design mode
button to be highlighted and thus generate the "macros are disabled blurb"
when trying to run any of the macros in the MacroReports project. I have
tried creating a whole new template for the offending project and copying the
userform and code to this new template, but it did not solve the problem.
What would cause a particular project to say the macros are disabled?

> > when I try to disable the design mode,
>    ?????????????
[quoted text clipped - 7 lines]
>
> Close document, reopen then Tools->Macros->projectname
singeredel - 26 Feb 2005 01:27 GMT
In case anyone is interested, I just discovered that the digital certificate
for this project had to be sgined in VBA. I had sgined it using Tools,
Options, Security in the document window, but when I checked under Tools,
Digital Certificate in VBA, it was not signed there. I am still unclear as to
how this all works, but now my project's macros are not disabled using
security of high.

> > when I try to disable the design mode,
>    ?????????????
[quoted text clipped - 7 lines]
>
> Close document, reopen then Tools->Macros->projectname
 
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.