Excel and locking Margins

[Rocks]

Hi

I have a Q regarding Excel...here it goes

I need to lock the margins of the workbook so that they can not be changed in the print preview or page setup....


Any Advice / Help would be great

Thanks inadvance,

Regards,
Rocks

[anilgoje]

Hi,
You can very well do that by using the following code

xlapp.Worksheets("Sheet1").PageSetup.PrintArea = "$A" & ":$I"

This will set the margin to I cell and remember you can manipulate it with the above code as required by you

Hope this help's you

[Rocks]

Cheers