View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Lock Print Setting

Does this mean you want to stop the users from adjust the page layout?

If yes, then maybe you can tie into the workbook_beforeprint event and just set
everything the way you want--essentially overriding any change the user makes.

If no, you may want to rephrase the question.

Ted wrote:

I have created a template document at work where a team of 15 use it to
complete accounting reconciliations. However, when it is printed out each
person has access to modify the print setting and resize the doucment in
various forms. So I was wondering if there is a way to lock this?


--

Dave Peterson