MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VB changes aren't saves with worksheet, why?

Posted by Ian on January 30, 2002 7:02 AM

Hi I am using Microsoft Excel 97 sr-2.
I am changing the scroll area in VB and when I save the worksheet, the next time I come to scroll down, the changes have not been saved, i.e. the field is blank. I have done this at home on 2002 and it saves and work fine. Anyone any ideas please.

Posted by Juan Pablo G. on January 30, 2002 7:04 AM

In 97 the scroll area is not saved with the sheet. Just like .Protect UserInterfaceOnly:=True isn't stored. You have to reset it every time.

Juan Pablo G.

Posted by Ian on January 30, 2002 7:20 AM

Thanks Juan.