View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay Northrop Jay Northrop is offline
external usenet poster
 
Posts: 10
Default Sub erroneously calls another sub

Greetings !

In my workbook, I have a 'change event' macro (started with the line
"Private Sub Worksheet_Change(ByVal Target as Range"). After much work, this
macro runs just fine.

My problem is that a totally separate macro, which I call
"Clear_Glass_Data", somehow calls the 'change event' macro into play. I'm
guessing that this happens because the "Clear_Glass_Data" changes many cell
values from TRUE to FALSE, therefore causing an "event" change. Is there a
way of isolating my "Clear_Glass_Data" macro so that it can't see or call
any other macros??

Thanks for your help,

Jay N.