Hello,
Is there a way to allow a table to expand rows when the sheet is protected?
Thanks,
Donny
Hello,
Is there a way to allow a table to expand rows when the sheet is protected?
Thanks,
Donny
No you must free the table to do this........
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
How to free?
First Unprotect the sheet then select the whole column which one need to free the press control 1 ->>> under the protection tab uncheck the protection then ok
Now press Alt->H->O->P check mark in open window on insert row then put the password and confirm the password and ok.
Hope it will help you...
Not sure how to do this can you take a look please? It is on the Entries sheet. The password to protect workbook is "bob" if needed.
Thank you
Now tell me what do you want??? There are too many sheets and what you want ??
I would like the Entries sheet table to expand when I start to type in new row please.
Have a look at this link
https://www.extendoffice.com/documen...xpandable.html
This does not help me thanks anyway.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks