Excel: Worksheet not showing
Posted on 2014-03-11
I've an excel workbook with 15 worksheets. But I've below concern:
1. Only 7 worksheets is being displayed in workbook with normal tab.
2. But once I open 'Visual Basic' development then it shows 15 worksheets.
3. Aforesaid 1st point, 7 worksheets is using rest 8 worksheets in formula(s) which are showing in 'Visual Basic' development.
My concern is that I want to see and analyze 8 worksheets as well.
Is there any way? FYI, I already check for 'Unhide sheet' but it shows empty listing.
Apart from this, how can I disable 'Insert' new worksheet in excel i.e. on worksheet tab --> right click --> 'Insert' option shall come disable.
Thanks. Looking forward for your response.