I would like the coding that works for the attainment/effort section to be extended to the dropdown menu's further down of the sheet unhide sheet save and view code.
I'm not sure I totally follow you here. Can you explain what it is doing currently, and what you're expecting? Saves me time trying to figure it out on my own, as I don't know your workbook.
Ken Puls, FCPA, FCMA, MS MVP (Excel)
Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.