Forum Discussion
Using Edit Ranges in a Table
I have a table that is going to be storing the entries made by users on a separate tab in the same workbook. The user will enter their data and then click a button which runs a macro to insert a row ...
Hi JazzHands
Would an option be to have the macro unprotect, then the data gets added and the macro re-protects?
Do you have a particular reason you want Row 2 to be editable?
Also when considering shared workbooks note that you can't use the traditional shared workbook functionality when Tables are present. However if you're using OneDrive Co-Authoring then you can but I'm not convinced that changes made via macro will work in that scenario