I'm protecting my sheet using
Theoretically, this should allow me to make any changes to the sheet through VBA without the need to unprotect the sheet. However, the code bugs out on the following line:
I already know that you need to run .Protect with UserInterFaceOnly every time the workbook is open, it's adding protection using my Workbook_Open event. But, it seems like there are exceptions to what can be manipulated on a sheet with VBA even if UserInterFaceOnly is set to True, in my case adding new columns. Is anyone able to confirm/deny this? I would prefer not to unprotect the sheet every time I run the macro, but I was curious if that's even an option.