Hi,
i have protected my sheets using Userfaceonly:=true (in workbook open event
procedure).
Some subs trying to copy ranges from one sheet to another keep getting an
error that i should unprotect my sheets first. I think this must be some kind
of bug resetting the userinterfaceonly argument to false since nowhere in my
code this property is changed or protection is changed. Has anyone
experienced this kind of behaviour ?

The Userfaceonly 'feature' wasn't implimented perfectly by MS. I use it and
test my code. If it runs, great, if not then I have to turn protection off
and on.

--
Jim
"lieven" wrote in message
...
Hi,
i have protected my sheets using Userfaceonly:=true (in workbook open
event
procedure).
Some subs trying to copy ranges from one sheet to another keep getting an
error that i should unprotect my sheets first. I think this must be some
kind
of bug resetting the userinterfaceonly argument to false since nowhere in
my
code this property is changed or protection is changed. Has anyone
experienced this kind of behaviour ?