My spreadsheet uses Protect Sheet and Protect Workbook. I have protected the range A1.. A3 in my spreadsheet to stop users from messing things up. Instead they have a macro which they can run which will change the formulas in those cells. But as those cells are protected .. the macro errors out when run.
Is there VB code I can put into the start of the macro that will un-protect those cells, then as it finishes .. puts the protection back on.
Thanks Bill
Is there VB code I can put into the start of the macro that will un-protect those cells, then as it finishes .. puts the protection back on.
Thanks Bill