ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Freeze Worksheet Tabs Excel 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/174664-freeze-worksheet-tabs-excel-2000-a.html)

Mike 2500

Freeze Worksheet Tabs Excel 2000
 
Is there anyway you can freeze the first worksheet tab so that it stays at
the beginning of the listed worksheets. (i.e. in a way similar to the freeze
pane function)

Dave Peterson

Freeze Worksheet Tabs Excel 2000
 
You can protect the workbook and lock the structure so that sheets can't be
moved, renamed, inserted or deleted.

tools|protection|protect workbook
and check Structure



Mike 2500 wrote:

Is there anyway you can freeze the first worksheet tab so that it stays at
the beginning of the listed worksheets. (i.e. in a way similar to the freeze
pane function)


--

Dave Peterson


All times are GMT +1. The time now is 11:46 PM.

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