?
Solved

How to unlock Excel Sheet Tabs

Posted on 2012-08-10
8
Medium Priority
?
541 Views
Last Modified: 2012-08-13
We have a Windows Excel 2010 spreadsheet that contains several Sheet.  We have given the various sheets names.  We have also made the tabs at the bottom have various colors.  Somehow the tabs are now locked and I can not unlock them.  I can not move the tabs, rename them or change their colors.  At first, I had no problems making these changes.  The worksheets and workbook are not "Protected" but the tabs seem to be locked.

Can anyone help us to unlock the tabs.  Any assistance will be appreciated.
0
Comment
Question by:sherman6789
  • 5
  • 3
8 Comments
 
LVL 24

Accepted Solution

by:
Steve earned 2000 total points
ID: 38281063
it does sound like the workbook is protected...

Could you run this little bit of code to see if it is and turn it off if it is.

Sub Macro1()

If ThisWorkbook.ProtectStructure Then
    MsgBox "Workbook protected"
    ThisWorkbook.Protect , False, False
End If

End Sub

Open in new window

0
 

Author Comment

by:sherman6789
ID: 38281405
Thanks for responding so quickly Barman.

I created the macro that you wrote and ran it.  Nothing seemed to happen.  I then clicked the "Protect Workbook" button and entered a password. I ran the macro again.  A box appeared on the screen that said "Workbook Locked".  It then asked for the password.  After I input the password.  I ran the macro again and nothing happened.

That makes me think that it is not locked or protected.  The sheets are also not protected.  I checked each one.

By the way, thanks for the macro.  I believe that I can use it in the future also.  This also helped me learn how to enter a macro and run it. I had never done that before.  Thanks.

Any other suggestions as to why I can not create, modify, color or rename the sheet tabs at the bottom.

This spreadsheet has existed for more than a year and I have never had a problem doing things with the tabs until now.  I have no idea when or how they were locked.

Thanks.
0
 

Author Comment

by:sherman6789
ID: 38281424
Sorry.  The message was "Workbook Protected" not "Workbook Locked".

WRS
0
Technology Partners: 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!

 
LVL 24

Expert Comment

by:Steve
ID: 38281526
Has the workbook been set to "shared"... this too can have the effect you describe.

Is it possible for you to post the workbook here?
0
 

Author Comment

by:sherman6789
ID: 38281531
GREAT NEWS.

For some reason, The tabs are now unlocked/unprotected.  It appears that when I ran your macro (BARMAN), it did not seem to be protected.  I then protected it with password, ran the macro again.  This time I unprotected the workbook.  It now is unlocked.

I will close this thread immediately.  If anyone has an idea of what happened, please let me know.  In any event, thanks to BARMAN for your help.

WRS
0
 

Author Comment

by:sherman6789
ID: 38281539
I sent my Great News reply before I saw your last message.  No.  We have not done anything with the shared capabilities.  We are overjoyed by the fact that it is now working.

WRS
0
 
LVL 24

Expert Comment

by:Steve
ID: 38281544
I think you will find it was protected, but not so that you could tell.

Doing an unprotect then protect will have fixed the issue.

was about to suggest  tehe following code as follow on:
ActiveWorkbook.ExclusiveAccess

Open in new window

0
 

Author Comment

by:sherman6789
ID: 38287844
FINAL COMMENT

All tabs ARE unlocked and working as expected.  We are able to do everything that we want to do with the tabs including: color changes, name changes, location, adding and deleting tabs, etc.
 
Thanks again.

WRS
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
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.

840 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