Copy and Paste Row Macro

[DDav]

Hi

I'm looking for a marco that will copy and paste a row when the sheet is password protected

Thanks
David

 

[MrKowz]

What row are you wanting to copy, and where are you wanting to paste it?

In order for the macro to copy/paste to a protected worksheet, the worksheet needs to be protected with a special declaration of "UserInterfaceOnly" which is done through VBA, or it needs to be unprotected/protected within the code.

 

[HRIS]

At the beginning of the macro include a line unprotecting the sheet or workbook. Then put your copy and paste code. At the end of the macro, include code to re-protect your sheet/workbook.

Protect/Unprotect code (you may want to change some of the settings I have):

'code to unprotect sheet
Sheets("Summary Sheet").Unprotect Password:="your password"
 
'code to re-protect sheet
Sheets("Summary Sheet").Protect Password:="your password", Contents:=True, Scenarios:= _
True, AllowInsertingRows:=True, AllowDeletingRows:=True, AllowSorting:= _
True, AllowFiltering:=True
Sheets("Summary Sheet").EnableSelection = xlNoRestrictions

 

[DDav]

Thanks, i'll look into UserInterfaceOnly.

I'm looking to copy row 73 and paste it in as row 72 - if that make sense

 

[DDav]

Thanks great, it works great, thanks for your help

Have a nice day

David