Then save this code, and go back to the workbook, click Developer > Macros.Ĥ. Note: In the code slice of Sheets("Master").Activate, you can change the Master to any sheet name as you need.ģ. Click Insert > Module, then copy and paste below code to the script. Press Alt + F11 keys to enable the Microsoft Visual Basic for Windows.Ģ. Here I introduce two VBA codes for you to handle this job.ġ. Now you want to lock a master sheet’s position for always visible, how can you handle it? If there are multiple sheets in a workbook, when you toggle to the last one sheet, the first sheet will be hidden in the sheet tab bar as below shown. How to lock a sheet position for always visible in Excel Workbook?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |