macros in excel application object

  • Thread starter Thread starter josef123
  • Start date Start date
J

josef123

Hi,

is there a possibility that excel macros are always executed, even if
excel is used as application object called from another application?
(Are macros in XLStart executed if excel is used as application
object.)

Thx, josef
 
Use workbook_open code in the workbook being opened.

Private Sub Workbook_Open()
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You could use Application.Run

Application.Run "myBook.xls!test_msgbox"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top