sherman6789
asked on
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.
Can anyone help us to unlock the tabs. Any assistance will be appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry. The message was "Workbook Protected" not "Workbook Locked".
WRS
WRS
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?
Is it possible for you to post the workbook here?
ASKER
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
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
ASKER
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
WRS
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:
Doing an unprotect then protect will have fixed the issue.
was about to suggest tehe following code as follow on:
ActiveWorkbook.ExclusiveAccess
ASKER
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
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
ASKER
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.