Is there a way to do this and still not have to change my macros.
I think you will have to change your macro so that it unprotects the
worksheet, does the copy/paste and re-protects the worksheet.
--
Jim
"Dajana" wrote in message
...
|I trying to copy/past info from one sheet to another that is protected.
| However even though the info copies into the sheet I have to debug my
macros
| for some reason since it always takes me automatically to the
VB page. I
| would not like to have to use password that the user needs to enter every
| time he tries to copy/paste info nor would I like to define users that
will
| be able to do that since I don't know who will be using the document. Is
| there a way to do this and still not have to change my macros.
|
| Thanks