VBA Copy, move, unlock active sheet and paste as values to a new workbook

I am currently using this VBA code, it allows me to copy, move and unlock the active sheet to a new workbook. How to copy them as VALUES only, not in original format with formula?

PHP Code: 

Public Sub CopySheetToNewWorkbook()
ActiveSheet.Copy
ActiveSheet.Unprotect Password:="dbf4ever"

End Sub 


This code is not doing what you say.
It is only copying the sheet and unprotecting the sheet. Nothing more

Hello again,

if you really want to move all the data from the active sheet into a new workbook, then you don't even need to unprotect the sheet.
Try it like this:

Please Login or Register  to view this content.