Can someone please help me with the following issue that I have
So I have a code that basically assigned to a button and when I hit the button it renames all the sheets in a way I want ECOSHEET 1 , 2, 3,etc… and if the order is wrong it reorders it.
The problem that I have is the hidden sheet ! so I have a button that uses the hidden sheet and it doublicates it, so the other button basically renames all sheets and reorders them, the problem that I have is the fact that the hidden sheet is also being counted in the code
So lets say I have
ECOSHEET 1 ( my main sheet where the buttons are )
ECO sheet that is hidden sheet
And the next sheets are as follow when they added ECOSHEET 2, ECOSHEET3,etc..
What is happening is the code is taking the hidden sheet and renaming it as well
So I have in tabs ECOSHEET1,ECOSHEET3,etc…. ( the ECOSHEET 2 now becomes the hidden one )
I need to revise the code in a way so it completely ignores the hidden sheet ! can anyone help please ? I am new to VBA and here is my current code , please ignore all comments as I was testing those THANK YOU FOR HELP
Moderators note: code tags added for you - this timePlease Login or Register to view this content.
Bookmarks