Protection of document properties ..??

OK, not sure if this is possible but here goes ...

I have created a master document in Excel, this will be used by
hundreds of people, they will be changing the information within the
document but what I need to do is protect the settings of the document
e.g. the page setup, whilst still letting changes to the information
contained within the document itself.

Is there anyway of doing this ?

Cheers.

Password protect the entire document, then unprotect the user data areas
....?
If users need to print off specific bits of it for their own use, create
interdependant user pages including just the data that they need (if that's
too cumbersome, then a new workbook linked to the master, tailored to their
needs?


"wingergbr" <thomashugh@hotmail.com> wrote in message
news:1128950808.868450.197110@g44g2000cwa.googlegroups.com...
> OK, not sure if this is possible but here goes ...
>
> I have created a master document in Excel, this will be used by
> hundreds of people, they will be changing the information within the
> document but what I need to do is protect the settings of the document
> e.g. the page setup, whilst still letting changes to the information
> contained within the document itself.
>
> Is there anyway of doing this ?
>
> Cheers.
>

Like the stuff under File|Page Setup???

I don't think you can protect this from changes. I think that the best you can
do is to apply the page setup you like each time the user prints or
printpreviews.

There is a workbook event that fires when the user tries to print:
workbook_beforeprint

Put all your code that resets these settings in that procedure.

You can read more about these kinds of events at:
Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

wingergbr wrote:
>
> OK, not sure if this is possible but here goes ...
>
> I have created a master document in Excel, this will be used by
> hundreds of people, they will be changing the information within the
> document but what I need to do is protect the settings of the document
> e.g. the page setup, whilst still letting changes to the information
> contained within the document itself.
>
> Is there anyway of doing this ?
>
> Cheers.

--

Dave Peterson

Thanks guys, I'll have a play around.