+ Reply to Thread
Results 1 to 7 of 7

Force Excel to direct user to a specific worksheet upon opening

  1. 11-23-2008, 11:43 PM #1
    somesunnyday
    somesunnyday is offline
    Registered User
    Join Date
    11-23-2008
    Location
    Australia
    Posts
    5

    Smile Force Excel to direct user to a specific worksheet upon opening

    Hi There, I'm new here. I hope I've posted this question on the right forum!

    How do I get a spreadsheet to open on a specific worksheet each time? I notice that when you're working in a spreadsheet, it seems to open up where you last made a change instead of at the front worksheet (which is what I want it to do). I hope this question makes sense.

    thanks in advance
    Reply With QuoteRegister To Reply
  2. 11-24-2008, 01:08 AM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,493

    Auto select sheet when open

    This can be done with VBA,Place this code in the workbook module
    Use this link to see where the workbook module is located
    http://www.contextures.com/xlvba01.html
    Please Login or Register  to view this content.
    Change the sheet name as required
    Macros will have to be enabled when the workbook is opened, for this to work.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 11-24-2008, 01:21 AM #3
    somesunnyday
    somesunnyday is offline
    Registered User
    Join Date
    11-23-2008
    Location
    Australia
    Posts
    5

    Didn't seem to work

    Hi davesexcel,

    I tried your tip but it didn't seem to work. I've attached the spreadsheet. Are you able to tell if I did it correctly or not?

    Cheers
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 11-24-2008, 01:57 AM #4
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,493
    Quote Originally Posted by somesunnyday View Post
    Hi davesexcel,

    I tried your tip but it didn't seem to work. I've attached the spreadsheet. Are you able to tell if I did it correctly or not?

    Cheers
    Follow the link in my 1st post to see where the workbook module is.
    here it is again......
    http://www.contextures.com/xlvba01.html#Workbook
    Reply With QuoteRegister To Reply
  5. 11-24-2008, 03:55 AM #5
    somesunnyday
    somesunnyday is offline
    Registered User
    Join Date
    11-23-2008
    Location
    Australia
    Posts
    5

    Workbook Module

    I did follow the instrcutions in your link orginally and pasted the code. I then renamed the "Sheet 1" section to no avail.
    Reply With QuoteRegister To Reply
  6. 11-24-2008, 03:20 PM #6
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,493
    Quote Originally Posted by somesunnyday View Post
    I did follow the instrcutions in your link orginally and pasted the code. I then renamed the "Sheet 1" section to no avail.
    Here is your example with the code in the correct place
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 11-24-2008, 06:11 PM #7
    somesunnyday
    somesunnyday is offline
    Registered User
    Join Date
    11-23-2008
    Location
    Australia
    Posts
    5

    Thanks

    thanks very much for your assistance. Much appreciated!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1