Apr 15 2020 03:21 PM
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 set the hidden property of the Range class".
I am not sure how to fix it or if there is a better way to do it.
Regards,
Sam
Apr 16 2020 02:03 AM
SolutionApr 16 2020 06:17 AM
@Jan Karel Pieterse Thank you Jan!
Oct 08 2020 06:16 PM
@Jan Karel Pieterse - When i select that setting feature it works while i am in the document. Even after saving, i open the document again the setting default back. I can not unhide and hide columns
Apr 16 2020 02:03 AM
Solution