Thank you!
I have only 1 "check box" button, and wrote hide/unhide macro using if statements. If False, do a hide rows and certain columns. If True, unhide etc etc.
Works great when the sheet is unprotected. If protected, errors and says it can run debug, etc.
I think what you are saying is to unprotect the sheet, do the hide/unhide, and protect it, all in the Macro.
Sounds like that might work! Thanks.
I am trying to make a complicated workbook into a chargeable product, and I am NOT a programmer--just a pretty good Excel user. If anyone can make it more of a product so it does not look like Excel, let me know--or what to do. Add-ins can help< i am told, but I think I am not capable of that--I can write complicated Macros, but that is all.
Someone want to help--let me know.
Thank you all.