Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
Tab key don't work in unprotected cells in a protected sheet | Excel Discussion (Misc queries) | |||
If Info. from one Sheet matches, send it to another sheet | Excel Discussion (Misc queries) | |||
What is the shorcut key for moving between protected sheet? | Excel Discussion (Misc queries) | |||
allwoing protected excell sheet | Excel Worksheet Functions |