Password Protection

MattB · Mar 5th, 2002, 06:41 AM

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 · Mar 5th, 2002, 07:22 AM

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 · Mar 5th, 2002, 07:26 AM

The protection isn't copied over though!

Sam W · Mar 5th, 2002, 07:40 AM

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 · Mar 5th, 2002, 11:02 AM

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 · Apr 24th, 2002, 04:13 AM

Hi there friend

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

Apr 24th, 2002, 04:13 AM	#6
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Hi there friend 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 __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 06:41 AM	#1
MattB Board Regular Join Date: Mar 2002 Posts: 62	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?

Mar 5th, 2002, 07:22 AM	#2
Sam W New Member Join Date: Feb 2002 Location: Louisiana USA Posts: 26	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.

Mar 5th, 2002, 07:26 AM	#3
MattB Board Regular Join Date: Mar 2002 Posts: 62	The protection isn't copied over though!

Mar 5th, 2002, 07:40 AM	#4
Sam W New Member Join Date: Feb 2002 Location: Louisiana USA Posts: 26	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 ]

Mar 5th, 2002, 11:02 AM	#5
jeffmfrank Board Regular Join Date: Feb 2002 Location: Arizona Posts: 72	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.