I have year filter ::::it contains years 2010 to 2017:
whenever i opens the documents the default selection should be current year(2017).it should reflect as 2018 in next year automatically.
Check out Can't use the sheet hiding/popping method in v10.1? and see if that solution will help you as well. If not, or you need help modifying it, please post a packaged workbook so we can better assist you.
Hope this helps!
Retrieving data ...