The Problem is that I have so many sheets in One workbook . I want to set for only one Sheet the gridline .but in Other Sheets Grids needs to be Come Automatically .So let me know the idea .how should I achieve this specific task using Macro ???.any help would be highly appreciated .Kindly see the attachment also .if you will Print Preview to Mamasita Calenderata sheet or Mamasita Tamarind mix . you will see the grid at the time of Print Preview but if you will see the Print Preview to tomato Sauce Sheet .you will not get the Grid in full page .So let me know please !!! .:(

Unless you set a print area grid lines will appear automatically only as data is entered, which is what one normally requires so i am not sure what you are asking.

Brian

One other point, I noticed stray 0 s in row 1 in some sheets this is caused by the code I gave you you should add a Row test to avoid users clicking in the heading rows and causing problems

Example
If Target.Column = 5 And Target.Row > 2 Then


Apologies for not thinking of this originally.

Brian