I have a workbook that contains 7 different hidden worksheets (English, Spanish, French, etc.). i also have a drop down validation cell on an instructions worksheet with the above mentioned worksheet names.
Will someone please guide me through the process of writing a vba script that will activate the hidden worksheet based on the criteria selected in the drop down???
What i ideally would like is for a user to open this file, see a drop down with language options, selects preferred language, and that worksheet appears.
Any help is greatly appreciated.
Bookmarks