Unlock All Tables in Multiple Sheets?
I have a workbook with 150 sheets. Each sheet has several tables that I locked. Is it possible to Unlock All the Tables at the same time?
Craig
Question marked as
Best reply
Hi Craig,
This might be possible with a script, but to what purpose?
Unlocking an object is necessary only when you want to directly manipulate that object. You can do that on only on the sheet that is visible, and you can see only one sheet at a time.
Unlocking all of the tables (and other objects) on a single sheet is quite easy:
Select one object.
Press command - A to Select All
Press option-command-L to Unlock.
Regards,
Barry