Excel 2007 : Hide and Unhide

**TANKERMAN** · 04-17-2012, 10:16 AM

Hey All,

I thought I had gotten away from fixing the problems at our terminal but I am wrong on that account.

My question is this; they have several sheets in a work book that are named Daily Reconc, Daily Reconc1, Daily Reconc2, Daily Reconc3 and so on for several sheets (could be as many as 15).

They only work with ONE sheet at a time which will cover several days of tank reconciliations. Now they are having issues in knowing which sheet they are using without having to open several sheets.

My thought is have a button that will close the Active sheet and open the next sheet in line. What I have is very basic

Sub HIde_Unhide ()

ActiveSheet.Visible = xlSheetHidden

which will hide the active sheet

I tried several different ways to unhide the next sheet but nothing seems to unhide the next sheet

I told them the best thing for the terminal would be a database but just the word database sends some of the management guys into panic mode.

Thanks for any help
Tankerman

**royUK** · 04-17-2012, 10:17 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here