Protection of document properties ..??

W

wingergbr

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.
 
D

Dave Peterson

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
 
Top