Help with Auto expanding table when locked?

[Jimmy110]

Hi All,

Hoping you can help...

I have a protected sheet that has a number of macro buttons that when pressed, use some VBA to unprotect, allow the macro to run, then reprotect the sheet.

My issue is, I also have a table that I need to auto expand while the sheet is protected.

I've tried unchecking the "locked" option in format for the cells that the table will expand into, and that doesn't make any difference?

So....is there a way to unprotect the sheet when something is entered into only cells A23 to A1000....allowing the table to expand and then, reprotect the sheet automatically after expansion?

Thanks for your help

James