Macro won't run

[broop]

I have created a module for each page in my workbook with a scrol
lock. I am running the macro and saving it, it works fine until i exi
out and go back in. I see the modules are still there but i have to d
the process all over again to have the scroll locks work. Why is th
scroll locks not staying when i close out and go back in?

Working in Excel 200

 

[JLGWhiz]

When you close a file, the memory for the controls is dumped. You can work
around that by making a Workbook_Open macro that resets your scroll lock
immediately upon opening the workbook.

 

[Patrick Molloy]

or code the workboos OPEN event

When you close a file, the memory for the controls is dumped. You can work
around that by making a Workbook_Open macro that resets your scroll lock
immediately upon opening the workbook.