Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specify ScrollArea in a Sheet
Hi there IS there a code to set the scrollArea as the follow: Code: -------------------- Sheet1.ScrollArea = "A1, A4, A7" -------------------- i mean to scroll, only, in the mentioned cells A1 A4 A7. Thank u -- helmekki ------------------------------------------------------------------------ helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939 View this thread: http://www.excelforum.com/showthread...hreadid=379684 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specify ScrollArea in a Sheet
Hi
Not with ScrollArea, the range must be one area But : Uncheck locked first in the properties of the three cells If you are using 2002 or 2003 you can protect your sheet and uncheck Select locked cells. If you use 97 or 2000 you must use code to do this. post back if you want a example -- Regards Ron de Bruin http://www.rondebruin.nl "helmekki" wrote in message ... Hi there IS there a code to set the scrollArea as the follow: Code: -------------------- Sheet1.ScrollArea = "A1, A4, A7" -------------------- i mean to scroll, only, in the mentioned cells A1 A4 A7. Thank u -- helmekki ------------------------------------------------------------------------ helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939 View this thread: http://www.excelforum.com/showthread...hreadid=379684 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specify ScrollArea in a Sheet
Good evening Helmekki You might have to clarify what you mean here, Hesham. You can certainly restrict a user to a RANGE, but if you want to restrict individual cells, you might be better off using the Tools Protection method. Use this to restrict a user to an area: Worksheets("Sheet1").ScrollArea="A1:B100" and this to undo it: Worksheets("Sheet1").ScrollArea="" is this what you meant? HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=379684 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit Scrollarea | Excel Worksheet Functions | |||
ScrollArea | Excel Discussion (Misc queries) | |||
Scrollarea | Excel Discussion (Misc queries) | |||
do I need ScrollArea and/or?? | Excel Programming | |||
Activesheet.Scrollarea | Excel Programming |