View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1312_] Rick Rothstein \(MVP - VB\)[_1312_] is offline
external usenet poster
 
Posts: 1
Default sheet1 tab staying still

I'm not sure why you are asking this question, but if you do something that
moves if from that position, you can always click/drag it back into
position.

If you meant via code, this will move Sheet1 into the first position on the
left...

Worksheets("Sheet1").Move befo=Worksheets(1)

Rick


"duckie" wrote in message
...
Can you have sheet 1 tab stay in left corner if you have 20 worksheets