Hi - I've tried searching other threads before posting to no avail..
The workbook I'm building contains performance data on individuals, who'll have access to this book & to their respective data. There are 11 worksheets in total and is consisting of 1 worksheet as the main page and 10 other worksheets that will hold 10 individuals performance data (1 worksheet = 1 person)
Each worksheet (apart from the 'main page'), I've placed as "Very Hidden" within the VBA. However, I want a hyperlink that will take you to the 'Very Hidden' page upon selecting a persons name within a data validation list on the 'main page'. I'm using the Hyperlink function which sits right underneath the data validation list.
On a side note (in case it changes anything), I'm also looking to restrict permissions so that only 'Steve' can view his worksheet.
Any help would be greatly appreciated!
Ben
The workbook I'm building contains performance data on individuals, who'll have access to this book & to their respective data. There are 11 worksheets in total and is consisting of 1 worksheet as the main page and 10 other worksheets that will hold 10 individuals performance data (1 worksheet = 1 person)
Each worksheet (apart from the 'main page'), I've placed as "Very Hidden" within the VBA. However, I want a hyperlink that will take you to the 'Very Hidden' page upon selecting a persons name within a data validation list on the 'main page'. I'm using the Hyperlink function which sits right underneath the data validation list.
On a side note (in case it changes anything), I'm also looking to restrict permissions so that only 'Steve' can view his worksheet.
Any help would be greatly appreciated!
Ben