Harcode values before protecting sheets.

[PaulM100]

I have the following macros that will delete some sheets, hardcode the remaining ones and it should protect every sheet with a password. The problem is that the protection macro activates before hardcoding the sheets, returning an error. How can I bypass this issue?
Also, how can I make sure that the only things that users are allowed to do is only to filter the data and use the slicers?

Please Login or Register  to view this content.

[PaulM100]

Fixed the issue by removing the second macro and adding the protection line to the second For Each. The problem is that one of the sheets has a table with lots of cube based formulas and after running the macro everything changes it's place as if the hardcoding part failed

[PaulM100]

Second fix: Fixed by changing second For Each to:

Please Login or Register  to view this content.