+ Reply to Thread
Results 1 to 2 of 2

trigger macro on file open

  1. #1
    Drew
    Guest

    trigger macro on file open

    I am trying to create a macro that will trigger when I open a workbook, but I
    am not at all familiar with Visual Basic. Is there a way to do this without
    writing VB code?

    Thanks!
    --
    Drew

  2. #2
    N10
    Guest

    Re: TRIGGER MACRO ON FILE OPEN


    "Drew" <[email protected]> wrote in message
    news:[email protected]...
    >I am trying to create a macro that will trigger when I open a workbook, but
    >I
    > am not at all familiar with Visual Basic. Is there a way to do this
    > without
    > writing VB code?
    >
    > Thanks!
    > --
    > Drew


    Drew

    Are you familar with the visual Basic editor.? If so
    you need to place code in the workbook_open event .

    Private Sub Workbook_Open()

    your code

    End Sub

    Such a macro would fire every time to load the workbook

    Best N10





+ Reply to Thread

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