Macro won't run
 

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

Working in Excel 2007


--
broop
------------------------------------------------------------------------
broop's Profile: http://www.thecodecage.com/forumz/member.php?userid=26
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=36994

Macro won't run
 

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.

"broop" wrote:


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

Working in Excel 2007


--
broop
------------------------------------------------------------------------
broop's Profile: http://www.thecodecage.com/forumz/member.php?userid=26
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=36994

Macro won't run
 

or code the workboos OPEN event

"JLGWhiz" wrote:

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.

"broop" wrote:


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

Working in Excel 2007


--
broop
------------------------------------------------------------------------
broop's Profile: http://www.thecodecage.com/forumz/member.php?userid=26
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=36994