Ernie Hatton
New Member
- Joined
- Jun 8, 2016
- Messages
- 9
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?
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?