Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect sheet and still copy
Is there a method to protect a sheet (specific cells "Locked/Hidden") and
still copy/cut/paste rows? As an example, in rows 1 thru 30 columns A, C, E, G, I, K, N, O, Q, S and U are Locked/Hidden. This makes it easier to tab thru the sheet, all other columns are not Locked or Hidden and last column used is V. If I want to copy/cut/paste any of the rows (1 thru 30) or copy a selection of cells (columns and rows) I have to "unprotect" the sheet perform the action and then protect the sheet. Same scenario to copy said row and or selection to another same style sheet. For me this is not a problem, for others it appears, this is a life altering event! -- Regards VBA.Noob.Confused XP Pro Office 2007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop select and copy of excel sheet in protect mode | Excel Programming | |||
Protect excel sheet and still copy text or object w/o unprotectin. | Excel Discussion (Misc queries) | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
Lock and protect cells without protect the sheet | Excel Programming | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming |