Results 1 to 5 of 5

Thread: [Resolved]Simple and Urgent

  1. Aug 10th, 2005, 01:44 PM #1
    Bartender
    Bartender is offline

    Thread Starter
    Member
    Join Date
    Jun 2005
    Posts
    41

    Resolved [Resolved]Simple and Urgent

    Hey,
    this must be a simple problem, but for the life of me I cannot figure it out.
    How can I make it so that excel selects a particular sheet every time this workbook is opened.
    When I open excel, I want the sheet to select the sheet named "Primer."
    Any help would be appreciated, I'll keep looking.
    Thanks!
    Last edited by Bartender; Aug 10th, 2005 at 03:21 PM.
    Reply With Quote Reply With Quote
  2. Aug 10th, 2005, 01:53 PM #2
    dannymking
    dannymking is offline
    Fanatic Member dannymking's Avatar
    Join Date
    Jul 2005
    Location
    Darlington, North East UK
    Posts
    677

    Re: Simple and Urgent

    VB Code:
    1. Sub AutoExec()

    2.  Sheets("Primer").Select

    3. End Sub

    Maybe..

    In a module by the way
    Danny

    Never Think Impossible

    If you find my answer helpful then please add to my reputation
    Reply With Quote Reply With Quote
  3. Aug 10th, 2005, 01:55 PM #3
    Webtest
    Webtest is offline
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Re: Simple and Urgent

    It may have to be named "Auto_Open"
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA
    Reply With Quote Reply With Quote
  4. Aug 10th, 2005, 01:58 PM #4
    dannymking
    dannymking is offline
    Fanatic Member dannymking's Avatar
    Join Date
    Jul 2005
    Location
    Darlington, North East UK
    Posts
    677

    Re: Simple and Urgent

    Yep thinking of access..
    Danny

    Never Think Impossible

    If you find my answer helpful then please add to my reputation
    Reply With Quote Reply With Quote
  6. Aug 10th, 2005, 03:20 PM #5
    Bartender
    Bartender is offline

    Thread Starter
    Member
    Join Date
    Jun 2005
    Posts
    41

    Re: Simple and Urgent

    Thanks, Works perfectly
    .. I think
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width