Hidden Sheet but only when I open in VBA (in excel workbook is visible)

[jevi]

Hi All,

It is not a hidden sheet with VBA as I know that trick.

I have an excel workbook and i have 3 sheets with different names, when I open the VBA I don't see the third sheet in VBA, but in the workbook in excel I do.

What is the trick? Thank you

 

[jevi]

@Thank you Rory.

@ Anthony thank you for your explanation...it is useful and helpful...in fact I don't understand any of the language used I even don't understand what that macro does because I saw today ( it sounds it creates a mess. I need to get that result but first I need to understand what it really does and as it is so old it is hard for me. I will use macrofun and then in case I don't find the solution I will open a new discussion with the topic. Thank you for the title also.

 

[daverunt]

Did I not point out what your issue was?

 

[jevi]

Did I not point out what your issue was?

@ Thank you Daverunt...I check everything from my phone is is confusing sometimes.