I wouldn't rely on the Activesheet. I'd use the keyword Me instead.
You never know how the code will be run and what sheet will be active.
Rick Rothstein wrote:
Good point... using "With Activesheet" should be good enough.
--
Rick (MVP - Excel)
"joel" wrote in message
...
Rick: You don't need parent in this case if yo uare manually chaging the
checkbox because the active sheet is the parent sheet. Besiodes the
change function is in the VBA sheet that corresponds to the worksheet
where the checkbox is located.
I occasionally forget this fact.
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=164975
Microsoft Office Help
--
Dave Peterson