macro adding
 

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.

macro adding
 

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.

macro adding
 

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.

macro adding
 

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.

macro adding
 

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.

macro adding
 

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.