I tried the folowing suggestions:
1. Change 'Private' to 'Public' regarding chkTweak_ Click. Did did
not work
2 Tried to put sbTheta ()in the same module as chkTweak_Click. Did
not work.
3. Refer to Sheet1.chkTweak. Did not work.
4. Put bulk of your code in standard module, and call it from event
handler, etc ...
I am pretty sure I can create new subs paint_yellow () and
display_messages (), which together do the same thing as as
chkTweark_Click, except that it will not show the checkbox as checked.
Well its a 70% solution.
Lesson I seemed to have learned:
1. Event handlers don't want to be called from subs that are located
in a different module, and
2. Sometimes even from a sub in the same module???
Am I wrong? Have a happy Fourth of july!!