|
|
|
|||||||
| 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 |
May 10th, 2002, 03:06 AM
|
#1 |
|
New Member
Join Date: May 2002
Posts: 4
|
i have received a spreadsheet via email and the workbook has been formatted to remove/hide the up/down, left/right scroll bars. can anyone help me get the bars back on screen, this is driving me crazy...any help much appreciated!
G |
|
|
|
May 10th, 2002, 03:18 AM
|
#2 |
|
MrExcel MVP
Join Date: Mar 2002
Location: Kobe, Japan
Posts: 1,420
|
Hi,
Please see the menu Tool(T)-Option(O) You can customize them. |
|
|
|
|
May 10th, 2002, 03:18 AM
|
#3 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: Auckland, New Zealand
Posts: 4,209
|
Quote:
Tools > Options > View Select the Horizontal scroll bar option Select the vertical scroll bar option
__________________
Kind Regards, Ivan F Moala From the City of Sails 
|
|
|
|
|
|
May 10th, 2002, 03:20 AM
|
#4 |
|
Board Regular
Join Date: May 2002
Location: Ipswich, Suffolk, England
Posts: 135
|
go to tools / options/ then tick the, left / right scroll bar, up /down scroll bar at the bottom of the window
|
|
|
|
|
May 10th, 2002, 03:20 AM
|
#5 |
|
New Member
Join Date: May 2002
Posts: 4
|
|
|
|
|
|
May 10th, 2002, 03:22 AM
|
#6 |
|
New Member
Join Date: May 2002
Posts: 4
|
just the trick!
thanks, and thanks again! G |
|
|
|
|
May 10th, 2002, 03:24 AM
|
#7 |
|
Board Regular
Join Date: Feb 2002
Location: Perth Australia
Posts: 1,567
|
Use Alt+F11 to go to the VB Editor and see if there is any scrolling restriction in the properties box.
Also look under tools, Options, View to see if scroll bars have been deselected regards Derek |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
