Thread: Print Allingment

I have a workbook with multiple work sheet and all of them are protected with same password with the condition user interface only and shared with others, mostly they are always changing the print alignment i have mentioned several times to them but they are not so how can i prevent them by changing only the print allingment but they should be allowed to print the worksheets.


Thanks
Muralidaran.

You can either increase the level of access provided by the protected sheet/workbook options so they can ONLY enter the required data ... or - less obviously - you can code the page layout in VBA and call it from the BeforePrint event procedure at workbook level. To do the latter, just record a macro of you setting up the sheet as you want it, then call that from the BeforePrint event. This way, even if they do change the sheet / print layout, it will be changed back to your settings before being printed.

Hope that helps.