I am unable to delete tabs in an existing spreadsheet. All of the abilities are grayed out when I right click on the tab except for view code, protect sheet, and select all sheets. All tabs are unprotected. I tried the solution at this link http://www.excelforum.com/excel-gene...lete-tabs.html but it did not work. Any other ideas?
Thanks!!
Have you tried unprotecting the workbook?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
I have unprotected all the tabs, is there a way to unprotect the workbook as a whole?
Thanks.
Yes. On the Review ribbon, you have (Un)Protect Workbook and (Un)Protect Worksheet commands...Originally Posted by gte932s
shot_excel_ribbon_protect.png
Last edited by Olly; 02-16-2016 at 11:10 AM.
That fixed it. The structure was still protected. Thanks for your help Olly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks