open worksheet based on month to specific sheet named after month and hide rest

Hi All, I am trying to get my workbook to open to a specific sheet depending on what month it is and automatically hide the rest, I have 12 sheets named after each month i.e january,feburary ect. The code i have manage to scrape up and put together via multiple searches seems to work but creates an error. When i open sheet it opens to january but then creates this error (method "visible" of object'_worksheet failed ) any help would greatly be appreciated see code below. i have this code in the Thisworkbook module

Please Login or Register  to view this content.

befor you make your loop, make that sheet oName visible, otherwise a certain moment it can happen that no sheet at all is visible and excel doesn't like that.
so before the for each ... you add "worksheets(oName).visible=true"

sorry tried adding the code you suggested before the for each,,, but it still creates exact same error ??

Suppose your sheet names "JaNuArY" to make it difficult.
maybe you should use strcomp or use "option compare text" above in your module, if it's still not working.

Please Login or Register  to view this content.

Originally Posted by bsalv

Suppose your sheet names "JaNuArY" to make it difficult.
maybe you should use strcomp or use "option compare text" above in your module, if it's still not working.

Please Login or Register  to view this content.

@ bsalv thank you so much this did it i really appreciate all the help thanks again