Hi All,
Please Please!!
Can someone help me with my coding and errors on my excel workbook.
I have tried the last three days to fix the problem.
There are hide and unhide coding with a check box in some of the sheets, that hides and unhide columns when the sheet is protected. Then also code to enable the use of outlines (+) when the sheet is protected.
In the first sheet I have an auto filter that I enable when I protect the sheet with my password.
The problem I think is when I close the sheet and reopen it, it protects everything on its own and changes my protection setting ex: I can’t use the auto filter and also you can select the protected cells that I checked to disable when protecting my sheets.
The errors I get are runtime errors, debug 1004.
I know this may be a lot to ask, but would appreciate the help.
Thanks in Advance!!
Please find uploading.com link for my file.http://uploading.com/files/45c23e75/...Projects.xlsm/
Bookmarks