Problem with scroll area

J

Juuljus

Hi,

I put a scroll area to my excel file in the sheet properties field. Now
I need to change it (make it bigger). I change it from A1:I28 to
A1:I32. It works. I then save the WB and exit. Next time I open the
file, it has changed it back to A1:I28.

Has anyone an idea what's wrong?

thanks,
Juuljus
 
G

Guest

To the best of my knowledge, the scroll area property has to be set each time
a workbook is opened. I am surprised it remains set to anything. Perhaps
you have code in the workbook_Open event that is setting it.
 

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

Scroll Area Problem 8
Dynamic scroll area 3
excel vbe scroll range - how to save? 2
Scroll Area 3
Setting Scroll Area 1
Scroll Area 1
How to restrict scroll area 4
Copy sheet and rename tab 4

Top