Problem with scroll area

[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

 

[Tom Ogilvy]

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.