Forum Discussion
Solved
VBA to hide set of columns is in conflict with protecting the sheet
Hello, i created VBA to hide a set of columns. But when i try to protect certain cells in sheet including the columns that will be hiden, i get the error message" Run time error1004, Unable to se...
- When you protect a worksheet, one of the options is to allow "Format Columns". If you check that box you can hide and unhide columns on a protected sheet.
When you protect a worksheet, one of the options is to allow "Format Columns". If you check that box you can hide and unhide columns on a protected sheet.
JKPieterse Thank you Jan!