View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris McFarland Chris McFarland is offline
external usenet poster
 
Posts: 2
Default Call vs. Run command

I am a little cofused between the Call and Run commands.
I have a hidden worksheet (testfile.xls) that loads every
time excel is open (Note: Thisworksheet.isaddin = True &
Macro Security Level is set to Medium).

From a new workbook I want to create a button that calls
a subroutine, MySub(), from testfile.xls. I tried to use:
Call MySub()
but it was not recognized. After a little research, I
used:
Run "MySub()"
and it seems to work. My question is what is the
difference between the Run and Call Commands? I thought
they were essentially the same functions.