how to ignore hidden sheet when renaming all visible sheets and reordering all visible she

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

Please Login or Register  to view this content.

Moderators note: code tags added for you - this time

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I have added code tags for you - this time Please use them in future

Also posted in Commercial Services

http://www.excelforum.com/commercial...ignore-it.html

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.