+ Reply to Thread
Results 1 to 2 of 2

Workbook Open event

  1. #1
    Forum Contributor
    Join Date
    05-14-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    155

    Workbook Open event

    Dear Experts,
    I am using below code and need help that if said (Database.xlsx) workbook is being used by another user, macro should popup a message that "Try to Run after some Time" and then exit the macro.

    Workbooks.Open Filename:=ThisWorkbook.Path & "\Database.xlsx"
    ActiveWindow.WindowState = xlMinimized
    ActiveSheet.Shapes("Rectangle 3").Visible = False
    ActiveSheet.Shapes("Rectangle 2").Visible = True
    Application.ScreenUpdating = True
    Call Macro5

    Please help me for the said matter.

    Thanks in advance.
    Rajeev Kumar

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Workbook Open event

    Did not tested:

    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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. Workbook Open Event
    By cameron213 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2013, 03:55 AM
  2. [SOLVED] VBA code for workbook open event
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2013, 10:52 AM
  3. WorkBook open Event
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2011, 06:02 PM
  4. WorkBook Open Event?
    By zplugger in forum Excel General
    Replies: 7
    Last Post: 12-10-2011, 02:28 AM
  5. Open workbook event
    By pmguerra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2010, 09:31 AM
  6. Opening workbook without workbook open event
    By davegugg in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-16-2009, 05:14 PM
  7. Open Workbook Event
    By newbie13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2008, 11:56 AM
  8. Workbook open event
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2006, 06:00 AM

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