here are some problems I found recently and would like some answers

1) The help window in VBA doesn't close. This started recently but cannot
get it closed unless I log off. Don't know why

2) Can anything be done to stop Worksheet_Change from recusively being
called when an entire row gets added or deleted. I added code to return if
the Target.address is not in the form $3:$3 so my code only gets called one.
Any suggestions.

3) Is there any way that the Worksheet_Change macro would know whatt action
called it. Needed tto know if an entire row was being added or deleted.
Didn't know how to tell the diffference.


4) Changing background color of cell does not automatically update
worksheet. I generated the function below. When I changed color of
referenced cell the value return by the functtion did not change. Can
anything be done tto havve excel recognize a color change and tthen
automatically reclculate the worksheet.

Function GetColorValue(Target As Range)
'
' GetColrovalue Macro
' Macro recorded 2/28/2007 by Joel
'

'
GetColorValue = Target.Interior.ColorIndex

End Function