Password Protection

[MattB]

Even if I password protect a sheet it is possible to copy the complete sheet and paste it into a new sheet.
Is it possible to stop this?

 

[Sam W]

Yes, you can copy the worksheet. The protection will be copied to. As far as I know there is not a way to prevent copying.

 

[MattB]

The protection isn't copied over though!

 

[Sam W]

Wait A sec. Go to tools, protection then choose protect workbook. That will keep any Worksheets in the Workbook from being copied.
Also if a worksheet is protected and copied to another location even in another workbook the protection is copied also.
This message was edited by Sam W on 2002-03-05 06:45

 

[jeffmfrank]

You can also format the cells to "hide" formulas. If the protected sheet is copied, I don't think the hidden formulas will paste. Just the values.

 

[gareth]

Hi there friend :wink:

Try this code in your module,alter it if you must to fit your needs

Sub myUnLock()
'This code will unprotect the sheet.
Application.EnableEvents = False
Application.DisplayAlerts = False
ActiveSheet.Unprotect ("admin")

'Add optional code here!

Application.EnableEvents = True
Application.DisplayAlerts = True

End Sub

;-b