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
Printable View
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
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
Cheers