Results 1 to 3 of 3

Thread: Pause worksheet for 10 sconds while opening the workbook - VBA

  1. #1

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    May be..

    Code:
    Private Sub Workbook_Open()
        
        Dim wksDefault      As Worksheet
        Dim wksNext         As Worksheet
        
        Set wksDefault = Worksheets("Sheet1")
        
        Set wksNext = Worksheets("Sheet2")
        
        Application.Goto wksDefault.Cells(1)
        
        Application.Wait Now + TimeSerial(0, 0, 10)
        
        Application.Goto wksNext.Cells(1)
        
    End Sub
    Last edited by Admin; 01-28-2013 at 09:48 PM.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Junior Member
    Join Date
    Oct 2012
    Posts
    11
    Rep Power
    0
    Thanks for the help, is working like a treat.

Similar Threads

  1. Trim all Cells in a Worksheet - VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 6
    Last Post: 08-21-2015, 08:22 AM
  2. Replies: 7
    Last Post: 05-17-2013, 10:38 PM
  3. Pause Between Two Macro Sub Routines
    By rafal1122 in forum Excel Help
    Replies: 2
    Last Post: 04-30-2013, 07:09 PM
  4. Print Nth Worksheet To Mth Worksheet using VBA
    By Ryan_Bernal in forum Excel Help
    Replies: 2
    Last Post: 02-28-2013, 06:57 PM
  5. Opening a Pdf file using VBA
    By littleiitin in forum Excel Help
    Replies: 2
    Last Post: 11-30-2011, 03:05 PM

Tags for this Thread

Posting Permissions

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