Forum Discussion
Shipwreck818
Oct 23, 2023Copper Contributor
Hide Tabs based on Value of cell range
I have a work project crating an excel sheet for the purposes of a legal proocedure based on a date range entered in Sheet2 (FC4007.5). The date range entered, as many as 1, to 7 variables are sh...
- Oct 24, 2023
My apologies, I forgot to mention that you should rename the sheet Pre Version 1 to Pre-Version 1 to be consistent with the spelling on the FC4007.5 sheet.
See the attached version
Shipwreck818
Oct 24, 2023Copper Contributor
Thank you for your response.
Forgive my lack of vba coding, but is this ment to overide the previous vode i have?
I applied this one and I am getting error code plus it hide all my rows regardless of the date entered.
HansVogelaar
Oct 24, 2023MVP
My apologies, I forgot to mention that you should rename the sheet Pre Version 1 to Pre-Version 1 to be consistent with the spelling on the FC4007.5 sheet.
See the attached version
- Shipwreck818Oct 25, 2023Copper ContributorPerfect , excatly what I needed. Thank you so very much!