Is it possible to eliminate all the extra rows and columns from a work sheet so that only the used area is shown.
I have a form that uses:
ROWS: 1-17
COLUMNS A - F
Can I eliminate the rest of the work sheet?
Thanks,
Travelersway
Is it possible to eliminate all the extra rows and columns from a work sheet so that only the used area is shown.
I have a form that uses:
ROWS: 1-17
COLUMNS A - F
Can I eliminate the rest of the work sheet?
Thanks,
Travelersway
Yes. Highlight the area you want to print, then from the File menu select Print Area>Set Print Area
Next go to File>Print Preview to review your selection. Is it what you wanted? If not, click Setup... at the top of the screen and adjust as desired (fit to one page, portrait/landscape, etc.)
HTH
Bruce
The older I get, the better I used to be.
USA
Thanks Bruce, but it's not the print that I need. I would like to have only the form that I've created displayed on the screen with the balance of rows and columns removed. Is it possible?
Travelersway
One way is to hold down the control key and highlight any unwanted columns and rows by clicking on the row numbers and the column letters. Then use Fill Colour set to white to hide any unwanted gridlines.
Cycling-rod,
Thanks, but that's not what I need either. I phrased it wrong. I see from another thread that I should have said "Limit the scrolling".
Gord Dibben had the answer to code the work book.
Private Sub Work Book_ Open()
sheets("Your sheet").ScrollArea = "A1:F17"
End Sub
That worked Great! But now I want to do multile forms within the work book and I can't make it happen, Any Ideas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks