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
Apple Event: May 7th at 7 am PT
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
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
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
I see what you mean, Barry.
The tip for unlocking al the tables one one sheet is very useful, thank you.
Craig
Unlock All Tables in Multiple Sheets?