ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   sheet1 tab staying still (https://www.excelbanter.com/excel-programming/406412-sheet1-tab-staying-still.html)

duckie

sheet1 tab staying still
 
Can you have sheet 1 tab stay in left corner if you have 20 worksheets

Rick Rothstein \(MVP - VB\)[_1312_]

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




All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com