Excel 2003: "Member or data not found" on Exiting Excel

[MCuthill]

Greetings Fellow Tek-Tippers,

I have a (hopefully) simple question of the group concerning Worksheet Protection and Control Objects.

I have developed a calculator of sorts for our staff to use, where a driver Combo-Box will set the Visibility, Link Cell, Cell Link Range of other Combo-Boxes based on the choice made.

Everything is working fine from a functionality standpoint, but my issue arose when I protected the worksheet (the sheet needs to be locked so formula cells cannot be edited). Once I protected the worksheet, an exception is generated when I "x" (close) out of Excel. If I "x" (close) out of the document within Excel, this exception is not thrown.

I assume, as my VBA is on the "_Change" of the Combo-Box, that Excel is trying to access this VBA upon exit, but as the application is closed, it is no longer accessible.

My question to the group is: any thoughts on ideas to keep the protection on the worksheet and not have this exception generated upon exitting MS Excel?

The exact error is:
Compile error:
Method or data member not found
the compiler then highlights the first line of VBA to be executed within the "_Change" subroutine.

Thanks in advance for all your assistance.

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[SkipVought]

Hi,

This is a VBA question.

Please post in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MCuthill]

Thanks Skip,

I wasn't 100% sure if it would be a setting in Excel or an addition needed in my VBA.

I will repost this in the VBA Forum.

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[SkipVought]

and please post the VBA code that you referred to above.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MCuthill]

Greetings All,

For reference purposes, the thread can be found here:
thread707-1659097

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."