How to copy/paste info into the protected sheet

D

Dajana

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
 
J

Jim Rech

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
|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
 
Top