"Ted" wrote in message
...
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?
Ted,
There was an important oversight in my recent posting on this subject.
After you have added the code to the workbook, you must rem out the
following code in the workbook deactivate event.

'Set MenuObject = Application.CommandBars(1).Controls("Print")
'MenuObject.Delete

It will try to delete a control that is not there yet.
Save the file, close, and then reopen. You can then go into the editor and
remove the ' from those lines. Save again, close, then reopen and all
should work.

Sorry,
Jay