Thread: macro adding
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MAK MAK is offline
external usenet poster
 
Posts: 20
Default 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.