Take it nobody can help..!

A

AndrewWilson2000

Take it nobody can help..!
Posted several times..!

Ive created several procedures within a "Utils" module in
my Normal.Dot, working fine. Got buttons on toolbars etc,
suddenly last week when trying to edit my code got
the message "Project unviewable" & "Project Locked".

I have not locked my project, my toolbar buttons still
work, and I can call the Subs from other procedures in
other Doc.Modules, but can't access my original code..?

does anybody have any suggestions, rather then re-writing
the procedures again from scratch...?(Should've made a
backup or export.
Tried writing a utility sub to export modules as .bas, but
cant access as is locked.!

Ive searched the MS KB.. Any assit, would be greatly
 
J

Jonathan West

Try using the Organizer to copy the module to a newly created template.
Alt-F8, then click the organizer button, select the destination template,
and copy the module across.

If that doesn't work, then you might have to accept that the template is
irretrievably corrupted, rewrite the code, remember to keep backups in
future, and chalk the whole event down to experience.

--
Regards
Jonathan West - Word MVP
MultiLinker - Automated generation of hyperlinks in Word
Conversion to PDF & HTML
http://www.multilinker.com
 
A

Andrew

Thanks for your prompt reply, I was just hoping there may
be a way to retreive. Bit mad with myself, usually keep a
copy as Text in a document. but failed to do so this time.
Never mind, lesson learned.
Thanks Again
 
M

Mark Goddard

Try loading the normal.dot file and then going to VBA.
The errors you're getting normally appear when you try
and access code an add-in when you don't have the
underlying template loaded.
 
M

Malcolm Smith

Indeed, an excellent example of why production code should never be placed
within Normal.dot . Any code which needs to be used should always be
placed in its own start-up template.

- Malc
www.dragondrop.com
 
T

Thomas M

Would this be the same basic problem as the one I posted in the thread:
Macro Works in Form, but not in Module?

I worked on it some yesterday. I copied all the code (just using Copy
and Paste) into the This Document module of a new document, but that
didn't have any effect.

--Tom
 
L

Larry

Bit mad with myself, usually keep a
copy as Text in a document. but failed to do so this time.

You mean you copy the code that's in the module, and paste it as text
into a document as your backup? That's a complicated and inefficient
way of backing up a template. If you lost your template, you would have
to recreate all your keystroke assignments and menu buttons. Why not
just make a copy of the template, name it something like Backup Copy of
Normal 10-24-03, and make sure it's included in whatever removable
backup medium that you use, as well as on your hardrive for quick
access?

Larry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top