userinterfaceonly and copy method
 

Does anyone know why protection with UserInterfaceOnly doesn't allow me to
copy one named range to another? And just to eliminate wasting time with
explanations I've already eliminated - yes, I have it on the worksheet open
event. Also have made sure the ranges are the same size, and I can copy just
fine if the sheet is unprotected, and the cells can be selected when the
protection has been applied. What else could be going on? Appreciate any
good clues - thanks!

userinterfaceonly and copy method
 

Couldn't duplicate the problem based on what is in the post. I set up a two
sheet test with sheet one password protected for user interface only. I was
able to copy with code from sheet one to sheet two.. Check your manual
settings for sheet protection to see what is checked. If you do not
otherwise specify in your code, those settings still apply.


"slarbie" wrote in message
...
Does anyone know why protection with UserInterfaceOnly doesn't allow me to
copy one named range to another? And just to eliminate wasting time with
explanations I've already eliminated - yes, I have it on the worksheet
open
event. Also have made sure the ranges are the same size, and I can copy
just
fine if the sheet is unprotected, and the cells can be selected when the
protection has been applied. What else could be going on? Appreciate any
good clues - thanks!