Results 1 to 5 of 5

Find if workbook_open exists

Threaded View

tonywig Find if workbook_open exists 12-10-2007, 07:11 AM
dominicb Good afternoon tonywig ... 12-10-2007, 08:14 AM
tonywig Worked an absolute treat.... 12-10-2007, 09:05 AM
dominicb Hi tonywig There's two... 12-10-2007, 09:43 AM
tonywig Thankyou so much. Excellent.... 12-10-2007, 09:49 AM
  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