Solved

Excel: Worksheet not showing

Posted on 2014-03-11
3
459 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 51

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 33

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

717 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