Add a button from the controls toolbox to the sheet to run this code to protect & lock the sheet
Transferring the results would be a little more complicated,an example work book would help![]()
Option Explicit Private Sub CommandButton1_Click() With ActiveSheet .Cells.Locked = True .Protect "secret" End With End Sub
Bookmarks