Scroll Area

  • Thread starter Thread starter George
  • Start date Start date
G

George

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting Scroll Area 1
Scroll Area Problem 8
set scroll property of ActiveX combobox in spreadsheet 1
How to limit scrollable area 3
Worksheet Scroll Increment 2
excel vbe scroll range - how to save? 2
limit scroll area of split window panes? 1
After running AddIn, application needs to be re-drawn 1

Back
Top