No Mr.Dave,
I wish to"not to run" a Sub function /Inactivate a Sub Function when I will
use another Function/Command Button.
I explained the program in detail in my previous thread.
Please Suggest me futher.
Regards,
Premanand Sethuraman.

"davesexcel" wrote:


I assume you want to run a macro from another macro


Application.Run "Book1!Macro1"
example:
Sub Macro4()
'
' Macro4 Macro
'
Range("G18").Select
ActiveCell.FormulaR1C1 = "=SUM(R[-15]C:R[-1]C)"
Range("G19").Select

Application.Run "Book1!Macro1"

End Sub


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539633