protect format - page setup
 

I've protected parts of my sheet, but also want to protect it's format. I
don't want the user to use page setup to alter the appearance. Any
suggestions?

protect format - page setup
 

Hello,
Did you find a solution cause I'm searching also a solution for this ?
Thanks
François

"kva" wrote:

I've protected parts of my sheet, but also want to protect it's format. I
don't want the user to use page setup to alter the appearance. Any
suggestions?

protect format - page setup
 

There's a workbook_beforeprint event that you can use to reset any changes to
the page settings.

I don't think you can protect it any other way.

François wrote:

Hello,
Did you find a solution cause I'm searching also a solution for this ?
Thanks
François

"kva" wrote:

I've protected parts of my sheet, but also want to protect it's format. I
don't want the user to use page setup to alter the appearance. Any
suggestions?

--

Dave Peterson