In my workbook I have a code on one worksheet that runs macros when the value of certain cells changes. I need to be able to clear the contents of those cells within a different code (in a module) without triggering the running of the other macros (but in any other instance they are run). Is there a way to 'disable' the in worksheet macro within my other macro to allow me to do this??
Bellow is a section of the code on my worksheet:
Please Login or Register to view this content.
Sorry, use a boolean flag,
so at the top
Public blnRunWorkSheetChange as boolean
then set this to be true or false
have an extra line at the start
if blnRunWorkSheetChange then
YOUR CODE
end if
on the delete macro, set the blnRunWorkSheetChange to be false, then true after the delete completes.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
or use
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Thans guys. I just tried your solution JosephP because it seemed simpler to implement and it worked perfectly so thanks!
Originally Posted by JosephP
or use
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks