Protect Formatting

M

manaadiar

Dear Andy, firstly thanks for your response.. But i think yo
misunderstood my question.. What i wanted to protect was the PAGE SETU
- means the margin settings, fitting to 1 page etc.. The cells and dat
protection i know can be protected as you said..

I just want the PAGE SETUP to be protected.. Means irrespective of wha
they update in sheet, if the sheet is set to fit 1 page wide x 1 pag
tall it should not allow the other users to change this setting..

Possible..??

cheers
manaadiar :confused
 
D

Dave Peterson

I don't think you can.

The closest I've seen is code in the workbook_beforeprint module that resets all
the page setup stuff that you want to fix.
 
Top