View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
p1518 p1518 is offline
external usenet poster
 
Posts: 2
Default How to force workbook to always open on the index sheet tab

Hi, I have a workbook, comprising several sheets, one of which is the Index
tab, and the rest a sheet/ tab for each user.

users often save the workbook while it is open on their tab, but i would
like to build in some VBA code somewhere, so that the workbook will always
open in the Index tab/worksheet, regardless of where it was last saved.

Could someone please assist me (remember I am a relative novice !) ?