Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: VB Code - easy if you know how!

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anyone pse tell me where to place VB code to ensure it is actioned whenever I open the spreadsheet (ie condition is active all the time)as opposed to placing the VB within a macro environment and having to run it each time I open said sheet.

    Many thanks

    Lee

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This should start it when the workbook is opened. Hope it helps Dan

    Private Sub Workbook_Open()
    ""VBA Code Here""
    End Sub

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just the ticket, many thanks dantb

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Anytime, Learning myself good luck !

  5. #5
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-18 11:01, LeeHitchen wrote:
    Can anyone pse tell me where to place VB code to ensure it is actioned whenever I open the spreadsheet (ie condition is active all the time)as opposed to placing the VB within a macro environment and having to run it each time I open said sheet.

    Many thanks

    Lee
    Lee,
    Look at this:
    http://www.mrexcel.com/board/viewtop...5542&forum=2&4
    Especially Mark O'Brien's answer
    Eli

  6. #6
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Eli, it's all starting to make sense at long last!

    Regards

    Lee

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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