 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006allow user to paste in a protected worksheet without unprotect it
I have a protected worksheet. How could I copy and paste within the same worksheet without unprotect it? Any help will be highly appreciated! If the paste-to range is unprotected you can paste into that range. By default all cells on a sheet are locked when the sheet is protected. CTRL + a(twice in 2003) to select all cells. Format>Cells>Protection. Uncheck "locked" and OK Now select the sections/rows/cells to protect and Format>Cells>Protection. Check "locked" and OK Tools>Protection>Protect Sheet The section/row locking does not work if you don't protect the sheet. Gord Dibben MS Excel MVP >I have a protected worksheet. How could I copy and paste within the >same worksheet without unprotect it? Any help will be highly >appreciated! Gord Dibben MS Excel MVP Thanks for your response. Please let me take this chance to state my question more clearly. In my worksheet, I have a column with all cells in that column locked. There are a few cells UNDER OTHER COLUMNS unlocked for user to input their data. Then the whole worksheet is password-protected. My question is how to allow user to copy one ROW and paste it into another row without unprotect the worksheet? Please keep it in mind that there is at least one cell in EACH ROW locked where user CAN NOT modify the value in that cell. Thanks and I am looking forward to hearing from you soon! ************************************************************************************************* > If the paste-to range is unprotected you can paste into that range. > [quoted text clipped - 18 lines] > > Gord Dibben MS Excel MVP I've tried your method, I'm able to paste, but the cells which I wanted to locked is pasted with unlocked. What I need is copy a row which contain locked and unlocked cells, then paste with locked and unlocked cells not paste with all unlocked cells. > If the paste-to range is unprotected you can paste into that range. > [quoted text clipped - 18 lines] > > Gord Dibben MS Excel MVP
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.