I have a file with a 'Main' sheet containing a number of countries and a series of hidden worksheets, each worksheet representing a country shown on the 'Main' tab. Conditions are as follows:
1. Every time the file is opened, all tabs, except 'Main' should be hidden.
2. On clicking a country in the 'Main' tab, there should be a prompt for a password (to be provided centrally but would be different for each worksheet) and on correct entry, the relevant country tab should be opened.
3. None of the other tabs should be accessible (due to confidential nature of the data).
4. Centrally, I should have access to all worksheets without the need for entering passwords for each of the tabs.
I guess I could use the wsSheet.Visible = False/True to toggle between hiding and showing the sheets but am at a loss on how to make the password work. Any help will be very much appreciated.
Attached is a file with no data but with relevant tabs.
Merry Christmas and a Very Happy New Year 2016.
Bookmarks