I hope that this problem has not been covered in the past but I could not find exactly what I need to do. First of all, I have a multi-sheet workbook used by other employees all with different resolutions on their monitors. I want each sheet of my workbook to open with the entire width of data viewed. Unfortunately, each sheet varies in width. I have set a scroll area for each sheet so I am not concerned about them scrolling beyond the data. I have tried setting a pixle width for each sheet but this just doesn't work with different resolutions. I am wondering if there is some way to have the area viewed in relation to a cell range? I have been looking but so far nada! With the present method, it is necessary to resize each sheet to be able to see all the data which is not a good thing.
Thanks so much for your help!