Issue with command button unhiding sheets

Please Login or Register  to view this content.

[/CODE]

Please Login or Register  to view this content.

I am having an issue with a command I am using,
I have a bunch of command buttons on my main sheet where each is used unhide one single specified sheet, however they don't always work. The goal of this button is to simply unhide the tab the sheet it referring to, but not go to that sheet yet...
Sometimes some of them will work in 1 click, sometimes it will finally work after 3 or 4 clicks, and sometimes not at all. It seems random when they work and when they don't.

Oddly, They will almost always work if I click it once and then Push the space bar right after.

Is there a problem with my formula below? or is there a way to tell automatically execute a space bar push afterwards? or to get it to always execute the command? any ideas? (side note, I tried changing to "True" to "xlSheetVisible") which didn't seem to help.

Please Login or Register  to view this content.

I also have the below command buttons for unhiding and going to the indicated worksheet, and these buttons always work fine.

Please Login or Register  to view this content.

Thanks!

ok, Since the second code I had for unhiding and going to the worksheet always works, I decided to try the below; essentially to go to the worksheet, then go back to the sheet i was on; I added screen updating so you don't see it flashing between screens. seems to be working, at least better than before.

Now I am wondering if i can add a test first to test if the wkst is hidden and if so execute the command, but if it is already unhidden I want it to do nothing. DO you know how to do this?

Please Login or Register  to view this content.