Solved

Excel: Worksheet not showing

Posted on 2014-03-11
3
423 Views
Last Modified: 2014-04-22
Hello Folks,

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.

Best Regards
0
Comment
Question by:MohitPandit
3 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 200 total points
ID: 39921154
HI,

I Suppose the sheets are "very hidden"

Type Alt+F11 to access the VBE.
On the left side VBE, you should see a Project Explorer window and a Properties window. If either of these is missing, it can be enabled from the View menu at the top of the Visual Basic Editor.
In the Project Explorer window, select the worksheet you want to unhide.
In the Properties window, locate the Visible property, the same way you did in the previous section of this article.
On the right-hand side of the list, set the value of the Visible property to xlSheetVisible, using the available drop-down selector. The worksheet should now be visible again.

Regards
0
 
LVL 32

Assisted Solution

by:Rob Henson
Rob Henson earned 100 total points
ID: 39921413
If you are working in Excel 2010 or later, there has been a bug in option to Right Click and insert sheet function anyway.

When using that option rather than just clicking the new sheet "tab", it freezes Excel and eventually crashes.

Is this why you are wanting it disbled? Don't know of a way to disable it other than word of mouth around colleagues not to use it.

Thanks
Rob H
0
 
LVL 5

Author Closing Comment

by:MohitPandit
ID: 40016694
Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel conversion issue with Sql server 14 46
Macro 6 50
Sum iF  based on a null cell 11 29
IF ELSE Statement in Excel Macro VBA 16 34
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now