Hello everyone.
So - here is the sample file.
I have done it roughly the looks like my file.
In the original file I have many more cities and worksheets.
In orange I show which lines should be hidden in each worksheet with the name of the city and be locked.
Then worksheets with names of cities are unlocked and to show hidden rows - >>> as it wants to unlock password.
I am very grateful to you all.
Reply With Quote