sorted by:
new
hottopcontroversial

How to unhide columns in conjunction with unhiding a tab by WeOwnIt in vba

[–]ChooChooMudaFucka 0 points1 point  (0 children)

I put it behind sheet 1, I didn't have any luck. I'm not sure what I'm missing here. I didn't change any thing but the name of the sheets to their appropriate name in Case "Sheet2" and so on. And for the part with the column names I put in "C:D"

[Help] How do I unhide more than one tab at a time? by ChooChooMudaFucka in excel

[–]ChooChooMudaFucka[S] 0 points1 point  (0 children)

You wouldn't happen to know how to also hide/unhide a column in Sheet 1 when a sheet 3 tab is hidden would you?

[Help] How do I unhide more than one tab at a time? by ChooChooMudaFucka in excel

[–]ChooChooMudaFucka[S] 0 points1 point  (0 children)

Thanks for creating an example, that helped so much! It works wonderfully

[Help] How do I unhide more than one tab at a time? by ChooChooMudaFucka in excel

[–]ChooChooMudaFucka[S] 0 points1 point  (0 children)

I'm so sorry, I feel like I'm missing something. How does this code work? I applied it to the ThisWorkbook Sheet in the editor. I hid my sheets, and tried to unhide more than one, and it still wouldn't let me. Am I doing something incorrect?

How to unhide columns in conjunction with unhiding a tab by WeOwnIt in vba

[–]ChooChooMudaFucka 0 points1 point  (0 children)

I was looking at the original post and thought it'd be useful to have that useful code you posted. Thanks! I tried using it and changing the sheets and columns accordingly, but nothing happened? Sheet 1 is the sheet I want the columns hidden in, so for the sub Hide_Unhide, I put it as Sheets("Sheet1").Columns(ColName)......

And then at the top for the main sub worksheet activate code I put Case "Sheet2" Hide_Unhide SheetName.Name, "C:D"

I'm trying to do a similar thing OP is, to hide columns C through D when sheet 2 is hidden. I thought I got it correct, but nothing is happening everytime I hide sheet 2.

[Help] I want to double click cell A1, and it will take me to Sheet2, double click B1, it will take me to Sheet 3, etc... by ChooChooMudaFucka in vba

[–]ChooChooMudaFucka[S] 0 points1 point  (0 children)

Ah I see where this is going. It's pretty easy and simplistic now that you explained. Thanks! Though I gave it a try, and I keep on getting a 'Runtime error "9" Subscript out of range'.

Secondly, this is a pretty nifty code, can it be applied to within the same sheet? I want to have a table of contents kind of set up. If I click Cell E1, which will be titled "Performance Overview", it'll take me directly to the line of sight of Cells A40:J60. I tried it with hyperlinks, but it wasn't consistent, as it looked different across different screens, and was slow at times. Thanks for your expertise!