#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Scroll Area

Hi.
In Properties set limit Scroll area, Save, Reopen, Properties goes into
default.
Is there any code to set it, at open etc.
Thank you
George.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 415
Default Scroll Area

George,
Yes, that property is not retained ; you have to set it each time, probaly
in the WorkSheet_Open event.
Worksheet(1).ScrollArea = "A1:D4"

NickHK

"George" tron.net...
Hi.
In Properties set limit Scroll area, Save, Reopen, Properties goes into
default.
Is there any code to set it, at open etc.
Thank you
George.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting Scroll Area Premanand Excel Programming 1 May 15th 06 09:40 AM
Scroll Area Paul Dusterhoft Excel Discussion (Misc queries) 8 September 21st 05 11:36 AM
How to restrict scroll area CyberBuzzard Excel Programming 4 March 23rd 05 02:37 PM
Scroll Area Ashman Excel Programming 3 September 18th 04 04:23 PM
how to set scroll area David W[_3_] Excel Programming 1 August 26th 03 04:56 PM


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"