+ Reply to Thread
Results 1 to 3 of 3

Initialize Event for workbook

Hybrid View

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    Initialize Event for workbook

    Hi

    Any way to create an initialize event for workbook just like userform initialize event where we can fire some code before the workbook is opened?

    Help would be greatly appreciated.

    Best Regards
    Imran Bhatti
    Teach me Excel VBA

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Initialize Event for workbook

    1. Create a Macro called Auto_Open() Placed in a Normal Macro Module

    2. Create a Macro called Workbook_Open() in the Workbook Macro Module
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Initialize Event for workbook

    Quote Originally Posted by ImranBhatti View Post
    fire some code before the workbook is opened?
    No, not if the code is in that workbook. It cannot possibly run until the workbook is opened.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to use the UserForm Initialize event to Initialize 3 listboxes in the same userform
    By Pimp_mentality in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-16-2016, 02:59 PM
  2. [SOLVED] Userform runs Initialize sub @ beginning of textbox AfterUpdate event w/out being called
    By chirp08 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-18-2016, 01:02 PM
  3. [SOLVED] How to deal with multiple sets of code in the Initialize Event of a userform
    By chin67326 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2015, 06:54 AM
  4. Initialize event to populate two Comboboxes?
    By fcb1900 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-21-2010, 05:01 PM
  5. Initialize range without reference to workbook
    By treyr in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-03-2010, 04:18 PM
  6. [SOLVED] User Form Initialize Event Issues
    By Randy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-04-2005, 07:30 AM
  7. [SOLVED] UserForm Initialize event doesn't fire reliably
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-15-2005, 09:41 PM

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