I have developed an Excel file with macro, which is passed to user. I want
to add coding in it by asking user to run another macro (my newly developed
macro). How can I do it?
Thank you very much in advance.

Mark,

View the code and add a user prompt to the worksheet object on activate....

select case msgbox "Would you like to run my macro", vbyesno,"Macro Run
Confirmation"
Case vbYes
run your macro
Case vbNo
exit sub
end select
--

Tech Whiz Tom
MS Access / Excel Applications Analyst


"Mak" wrote:

I have developed an Excel file with macro, which is passed to user. I want
to add coding in it by asking user to run another macro (my newly developed
macro). How can I do it?
Thank you very much in advance.

Sub ExistingMacro()
If MsgBox("Run my new macro?", vbYesNo) = vbYes Then NewMacroName
End Sub

Sub NewMacroName()
MsgBox "Hello from NewMacroName"
End Sub

HTH,
Bernie
MS Excel MVP


"Mak" wrote in message
...
I have developed an Excel file with macro, which is passed to user. I want
to add coding in it by asking user to run another macro (my newly developed
macro). How can I do it?
Thank you very much in advance.

Thanks for your reply but not my wish. Maybe I mislead you.

I want to insert some codings from one Sub (in my newly developed Excel
file) to another Sub (in another Excel file). Any ideas?

"Bernie Deitrick" wrote:

Sub ExistingMacro()
If MsgBox("Run my new macro?", vbYesNo) = vbYes Then NewMacroName
End Sub

Sub NewMacroName()
MsgBox "Hello from NewMacroName"
End Sub

HTH,
Bernie
MS Excel MVP


"Mak" wrote in message
...
I have developed an Excel file with macro, which is passed to user. I want
to add coding in it by asking user to run another macro (my newly developed
macro). How can I do it?
Thank you very much in advance.

See Chip Pearson's site.

http://www.cpearson.com/excel/vbe.aspx


Gord Dibben MS Excel MVP

On Tue, 17 Mar 2009 09:36:01 -0700, Mak
wrote:

Thanks for your reply but not my wish. Maybe I mislead you.

I want to insert some codings from one Sub (in my newly developed Excel
file) to another Sub (in another Excel file). Any ideas?

"Bernie Deitrick" wrote:

Sub ExistingMacro()
If MsgBox("Run my new macro?", vbYesNo) = vbYes Then NewMacroName
End Sub

Sub NewMacroName()
MsgBox "Hello from NewMacroName"
End Sub

HTH,
Bernie
MS Excel MVP


"Mak" wrote in message
...
I have developed an Excel file with macro, which is passed to user. I want
to add coding in it by asking user to run another macro (my newly developed
macro). How can I do it?
Thank you very much in advance.

Thank you. It works.

"Gord Dibben" wrote:

See Chip Pearson's site.

http://www.cpearson.com/excel/vbe.aspx


Gord Dibben MS Excel MVP

On Tue, 17 Mar 2009 09:36:01 -0700, Mak
wrote:

Thanks for your reply but not my wish. Maybe I mislead you.

I want to insert some codings from one Sub (in my newly developed Excel
file) to another Sub (in another Excel file). Any ideas?

"Bernie Deitrick" wrote:

Sub ExistingMacro()
If MsgBox("Run my new macro?", vbYesNo) = vbYes Then NewMacroName
End Sub

Sub NewMacroName()
MsgBox "Hello from NewMacroName"
End Sub

HTH,
Bernie
MS Excel MVP


"Mak" wrote in message
...
I have developed an Excel file with macro, which is passed to user. I want
to add coding in it by asking user to run another macro (my newly developed
macro). How can I do it?
Thank you very much in advance.