|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Apr 30th, 2002, 05:21 PM
|
#1 |
|
Board Regular
Join Date: Apr 2002
Location: Puerto Vallarta, Mexico
Posts: 869
|
Here it is, dumb question time again. I have a very large list that is several columns wide and up to 10000 rows long. At the top of this list, I have an auto shape in the form of a button labled "PRINT". I would like the user to be able to scroll thru this list, side to side or up and down, but would like the "PRINT" button to always remain visible, IE, not move with the list contents so that the user at any time can click on it without haveing to return to the home position. Is this possible?
|
|
|
|
Apr 30th, 2002, 05:22 PM
|
#2 |
|
Board Regular
Join Date: Mar 2002
Location: Sydney/Brisbane , Australia
Posts: 539
|
Why don't you freeze the panes below the button?
|
|
|
|
|
Apr 30th, 2002, 05:23 PM
|
#3 |
|
Board Regular
Join Date: Feb 2002
Posts: 7,743
|
Click a cell below the Print. Go to Window/Freeze Pane
|
|
|
|
|
Apr 30th, 2002, 05:39 PM
|
#4 |
|
Board Regular
Join Date: Apr 2002
Location: Puerto Vallarta, Mexico
Posts: 869
|
LOL, thanks guys, I said it was a dumb question. Not thinking good tonight
|
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
