Solved

Excel: Worksheet not showing

Posted on 2014-03-11
3
439 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 AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
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!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

832 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