Any assistance on this macro would be appreciated. I have searched the forum and not found anything. I have an Excel 365 Macro that I want to Paste Special into a range in a protected worksheet. I manually preselect the values in another spreadsheet to be copied before running the Macro. I only want the values pasted so I use this. However when it completes, the highlighting and protection (Locked) are changed for the range of cells. How can I just paste the values? Below is what I have tried.
Sub Macro9()
'
' Macro9 Macro
'
' Keyboard Shortcut: Ctrl+m
'
Application.ScreenUpdating = False
Sheet1.Unprotect Password:=""
Worksheets("Sheet 1").Range("E15:E110").PasteSpecial xlPasteValues
Application.ScreenUpdating = True
Sheet1.Protect Password:=""
End Sub