?
Solved

how do i enable an  unprotected sheet which is disabled in office 2007

Posted on 2009-05-05
1
Medium Priority
?
288 Views
Last Modified: 2012-06-21
I am using microsoft office 2007. In one file that has macro's which i have saved the information as an  .xls has a tab under reviwe-changes-unprotected sheet which is disabled. I want to an able this sheet so as to make some changes and i cannot do that.

How do i enable this disabled sheet?
0
Comment
Question by:Mposhomali
[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
1 Comment
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 1500 total points
ID: 24311495
What do you mean by disbled, Hidden - in which case right click a tab and select unhide selecting your sheet.

Chris
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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 article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

764 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