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 |
All times are GMT +1. The time now is 05:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com