How to unlock Excel Sheet Tabs

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.
sherman6789Asked:
Who is Participating?
 
SteveConnect With a Mentor Commented:
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
 
sherman6789Author Commented:
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
 
sherman6789Author Commented:
Sorry.  The message was "Workbook Protected" not "Workbook Locked".

WRS
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
SteveCommented:
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
 
sherman6789Author Commented:
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
 
sherman6789Author Commented:
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
 
SteveCommented:
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
 
sherman6789Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.