Results 1 to 5 of 5

Find if workbook_open exists

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-26-2005
    Posts
    108

    Find if workbook_open exists

    How can I (using VBA) detect whether or not a workbook_open macro exists in a workbook?

    I've "guessed" at ...

    ThisWorkbook.VBProject.VBComponents("Workbook_Open").Name
    ... but that doesn't seem to work (error 9 - subscript out of range).

    Can anyone help?
    Thanks in advance.
    Last edited by VBA Noob; 12-10-2007 at 09:07 AM.
    Tony

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1