Is this possible?
I have a workbook with 65 seperate worksheets. The first 2 worksheets have a search macro with a find button so when entering a number it will take you to the worksheet that contains that number. I want to lock this down for our Service Desk to use and make it easy to navigate. What I want is to lock the first 2 worksheets in place so if a number is entered and you are taken to worksheet 63 for example, you can still see the first 2 worksheet tabs on the left so it's easy to enter another search number if you need to rather than having to go back to the first worksheet.
I have seen a macro that will move the search worksheet to be to the left of whatever tab you make active but this is not ideal for my requirements.
Is what I'm asking for possible?
Bookmarks