Is it possible to hide a sheet in a workbook referencing to the sheet that we want to hide by its index number ?
i know you can do it by its name but i couldnt find a way to do it by its index number
thank you in advance
Is it possible to hide a sheet in a workbook referencing to the sheet that we want to hide by its index number ?
i know you can do it by its name but i couldnt find a way to do it by its index number
thank you in advance
You will have to identify the index number, loop though the worksheets and return the id number when the name is known.
And index number generally does not change but a sheet name can so that's the problem
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Mr Keebellah
thank you very much for your response.
so you mean the only way to hide the sheet by its index number is to loop through?
Yes, because (as far as I can see it) the index number does not say anyhting about the sheet name.
Mr Keebellah
thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks