ThisWorkbook sheet is disappeared

%3CLINGO-SUB%20id%3D%22lingo-sub-1537498%22%20slang%3D%22en-US%22%3EThisWorkbook%20sheet%20is%20disappeared%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537498%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20writing%20a%20Macro%20in%20an%20Excel%20sheet.%26nbsp%3B%20I%20had%20to%20close%20and%20open%20the%20Workbook%20few%20times%20so%20as%20to%20witness%2Fcheck%20if%20the%20auto%20population%20of%20few%20drop-down%20boxes%20etc%20is%20working%20or%20not.%26nbsp%3B%20During%20this%20course%20of%20action%2C%20'ThisWorkbook'%20sheet%20under%20VBAProject%20(visible%20in%20Project%20Explorer)%20got%20disappeared%20automatically.%26nbsp%3B%20Now%20I%20am%20struggling%20to%20get%20it%20back.%26nbsp%3B%20Could%20you%20please%20provide%20a%20working%20solution%20for%20this%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1537498%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I am writing a Macro in an Excel sheet.  I had to close and open the Workbook few times so as to witness/check if the auto population of few drop-down boxes etc is working or not.  During this course of action, 'ThisWorkbook' sheet under VBAProject (visible in Project Explorer) got disappeared automatically.  Now I am struggling to get it back.  Could you please provide a working solution for this ?

0 Replies