Run time error 1004 only immediately after opening protected workbook

Hello all,

After opening a protected workbook, all of my macros work except for one that changes the color scale on a map on the interface. I receive a Run time 1004 error. However, if I unprotect the workbook, it works just fine. I can even reprotect the workbook, and it will work; I only receive the error immediately after opening the workbook while it's still protected.

The code is lengthy but is listed below. ***'s mark the line where the error is given.

Please Login or Register  to view this content.

Any direction would be greatly appreciated. Thanks!
Joe

Unprotect the workbook in your code to prevent the error.

For example:

Please Login or Register  to view this content.

Let me know if this works

BigBas,

This did work! Thanks so much!

Joe

Happy to help