Print Setting on A4 with VBA and protect sheet from copying to other sheet

[mangesh.mehendale]

Dear All,
I have inserted a code which will check empty cells and then will show print preview its working fine but I am not sure is it correct or not??

Also note If user copied entire sheet and pastes to other sheet its getting unprotected.. So what I want is if user copied entire sheet to new sheet it would also automatically get protected with same password "1122"

But the problem will not full resolved because there is possibility that user copy and paste entire sheet to new workbook..