Protect Formatting

  • Thread starter Thread starter manaadiar
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Protect Formatting 1
Printing worksheet to fit "blank" pages tall. 3
Print 1 tall/1 wide won't expand out to margins 2
Printing Issue in Excel 2007 1
Print Fit To Not Working 1
protect cell format 1
Print a worksheet to a page 4
protection 2

Back
Top