Thread: Inactivating a Sub Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Inactivating a Sub Function
You can use a boolean

Ad the top of your module add
Public stoprun As Boolean

In the sub you can set it to True and in the other one use this (first line)

If stoprun = True Then Exit Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Premanand" wrote in message ...
When I am using another Sub Function, I wants to inactivate another Sub
function.
Please suggest how can we do it?


Reply With QuoteReply With Quote