+ Reply to Thread
Results 1 to 2 of 2

PERSONAL.XLSB running before Excel has loaded

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    01-30-2014
    Location
    England
    MS-Off Ver
    MS Office 2010, 2007, 2003
    Posts
    149

    PERSONAL.XLSB running before Excel has loaded

    Hi again
    (Previous thread: http://www.excelforum.com/excel-prog...is-opened.html)

    Using the code that romperstomper gave, I've put part of my macro in, but the first part is an If function which checks whether a string is present in specific cells.

    ...
    If ActiveCell.Value = "" Then
    GoTo Part
    Else
    End If 
    ...
    Is there any way to stall the macro from running to let the file load properly please?

    I've tried a few Application.Waits and Application.Refresh but got nowhere.

    Thanks again

    Aaron

  2. #2
    Forum Contributor
    Join Date
    01-30-2014
    Location
    England
    MS-Off Ver
    MS Office 2010, 2007, 2003
    Posts
    149

    Re: PERSONAL.XLSB running before Excel has loaded

    Any help is appreciated

+ 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. Replies: 1
    Last Post: 08-07-2013, 09:12 PM
  2. Run-Time Error 1004 When Running Macro from Another Personal Workbook (xlsb)
    By vcs1161 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2013, 12:05 PM
  3. Replies: 0
    Last Post: 05-10-2012, 09:22 AM
  4. Macros in Personal.xlsb not available when Excel is opened from another app
    By Muskett32 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2012, 02:57 AM
  5. Personal.xlsb crashes excel
    By Lippert in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-31-2010, 06:40 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