code for veryhide sheet and unhide another one

[mazan2010]

Hello everyone
I have two codes
one code in sheet list that will copy data from sheet list to sheet mylist and also very hide sheet list
another code in my list sheet that will when press unhide sheet list and veryhidde sheet mylist


the code work well for one time but after that give error with the following line

Please Login or Register  to view this content.

what the wrong made itgive error after first time

[davesexcel]

You cannot have all sheets hidden, one sheet has to be left unhidden

You also cannot select a hidden sheet.

Why do you want to mess around with xlSheetVeryHidden anyway?

[mazan2010]

yes this what i need , i need move between sheet list and sheet mylist
so one will be always unhide and other will be hide

[davesexcel]

Then you need to unhide one sheet before hiding the other

[mazan2010]

Thank you so much for your advice and notes
its work well now with this modification

Please Login or Register  to view this content.

[davesexcel]

Here is a cleaner code you can practice with, avoids having to select worksheets

Please Login or Register  to view this content.

[mazan2010]

@davesexcel
thank you for your cleaned code I used it but I add to it hide and unhide option because I think it's only for copy data if I understand correct
the code as the follow

Please Login or Register  to view this content.

[davesexcel]

The code will copy and paste to hidden worksheets you should not have to unhide them

[mazan2010]

understand, good, thank you so much