Re: Macro making

From: Phil (I.fix.probs_at_for.you)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 09:22:11 -0400

Ok, same theroy though. Edit the macro so that it unlocks the ***, does it
functions, then locks the *** again. I'm more of a excel macro person, so
the experts in the word group should be able to help you out with the syntax
for the code.

KIT wrote:
> Thanks
> It's a Word document im working on
>
>
> I assume you're talking about excel. If you lock/protect
> the document and
> you have a macro that edits/changes cells, then you can do
> one of two
> things. Either check the boxes to allow the edit you need
> or edit the macro
> code to unlock the cell, edit it, then lock it again.
> The folks in the excel newsgroup can help you out.
>
> KIT wrote:
>> when recording the macro, the first thing i'd like it to
>> do is Lock/Protect the document. Also, only allow the
>> user to make changes in certain "Mail-Merged" drop down
>> fields.
>> Problem is when it's
>> locked it automatically stops producing the macro