Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
window size/scroll
Hello,
is there any code out there that does the following: As I move (increase or decrease) excel window size with mouse, spreadsheet moves with it. Also is it possible to disable the scrolling in excel? Thanks for the help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
window size/scroll
for scrolling, you can hide the scollbars on the window under Tools=Options
(or with code). You can set the scrollarea property of the worksheet. If you maximize the spreadsheet, then it won't be a problem. -- Regards, Tom Ogilvy "David" wrote: Hello, is there any code out there that does the following: As I move (increase or decrease) excel window size with mouse, spreadsheet moves with it. Also is it possible to disable the scrolling in excel? Thanks for the help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
window size/scroll
Hi Tom,
I would like to do it with code. I will do that while recording macro so I can see the code, then use it. Do you have any input about the other question (size of the window adjustment) I appreciate your help "Tom Ogilvy" wrote: for scrolling, you can hide the scollbars on the window under Tools=Options (or with code). You can set the scrollarea property of the worksheet. If you maximize the spreadsheet, then it won't be a problem. -- Regards, Tom Ogilvy "David" wrote: Hello, is there any code out there that does the following: As I move (increase or decrease) excel window size with mouse, spreadsheet moves with it. Also is it possible to disable the scrolling in excel? Thanks for the help |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
window size/scroll
Hi
Not sure i understand the first question. To prevent scrolling, one way would be to set the ScrollArea property of the Worksheet object to a specific range so that the user cannot scroll that range, say A1:O35. However, in xl2k, this setting is not saved with the book so you have to set it in the Workbook_Open sub. Not sure whether or not this setting is saved with the book in xp or 2003. -- Regards, Sébastien <http://www.ondemandanalysis.com "David" wrote: Hello, is there any code out there that does the following: As I move (increase or decrease) excel window size with mouse, spreadsheet moves with it. Also is it possible to disable the scrolling in excel? Thanks for the help |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
window size/scroll
Hi Sebastienm
do you know the code/commands to set the range for scroll bar? Thanks for your help "sebastienm" wrote: Hi Not sure i understand the first question. To prevent scrolling, one way would be to set the ScrollArea property of the Worksheet object to a specific range so that the user cannot scroll that range, say A1:O35. However, in xl2k, this setting is not saved with the book so you have to set it in the Workbook_Open sub. Not sure whether or not this setting is saved with the book in xp or 2003. -- Regards, Sébastien <http://www.ondemandanalysis.com "David" wrote: Hello, is there any code out there that does the following: As I move (increase or decrease) excel window size with mouse, spreadsheet moves with it. Also is it possible to disable the scrolling in excel? Thanks for the help |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
window size/scroll
From Excel's online help:
" ScrollArea Property Returns or sets the range where scrolling is allowed, as an A1-style range reference. Cells outside the scroll area cannot be selected. Read/write String. Remarks Set this property to the empty string ("") to enable cell selection for the entire sheet. " eg given the Worksheets(1).ScrollArea = "a1:f10" -- Regards, Sébastien <http://www.ondemandanalysis.com "David" wrote: Hi Sebastienm do you know the code/commands to set the range for scroll bar? Thanks for your help "sebastienm" wrote: Hi Not sure i understand the first question. To prevent scrolling, one way would be to set the ScrollArea property of the Worksheet object to a specific range so that the user cannot scroll that range, say A1:O35. However, in xl2k, this setting is not saved with the book so you have to set it in the Workbook_Open sub. Not sure whether or not this setting is saved with the book in xp or 2003. -- Regards, Sébastien <http://www.ondemandanalysis.com "David" wrote: Hello, is there any code out there that does the following: As I move (increase or decrease) excel window size with mouse, spreadsheet moves with it. Also is it possible to disable the scrolling in excel? Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to save a desired window size but hv window comeup fullsz by d | Excel Discussion (Misc queries) | |||
using scroll wheel in vba window | Excel Discussion (Misc queries) | |||
VBE Window will not scroll with wheel mouse | Excel Programming | |||
Scroll the window to the top - frozen rows | Excel Programming | |||
Can't scroll in code window | Excel Programming |