I have a spread sheet containing many macros one of which is Worksheet_SelectionChange macro. All macros work as expected but I am unable to protect t

[Ernie Hatton]

Hi All
I have a spread sheet containing eight macros all of which function correctly. One of the macros is a Worksheet_SelectionChange macro and when I come to protect parts of the worksheet I get an error message directing me to debug the SelectionChange macro which, in the unprotected worksheet, works perfectly. Is it possible to protect a worksheet containing this kind of macro?

 

[Fluff]

Yes, but you need to unprotect the sheet at the start of the code & reprotect it again at the end.

 

[Ernie Hatton]

Yes, but you need to unprotect the sheet at the start of the code & reprotect it again at the end.

Hi Fluff- Thank you for the reply, I always do as you say but I must admit you gave me a very good clue. I did not turn off 'protect' before selecting the column to be unprotected, this resulted in the whole spreadsheet becoming protected when the column was selected giving the impression that protection was not working correctly.

I then forgot to turn protect again when the task was done, but I have learned that lesson now.

Once again many thanks, it is always the simple things that catch you out!

Regards
Ernie

 

[Fluff]

Glad you sorted it & thanks for the feedback.