![]() |
How to disable copy of protected excel worksheet?
I protected one excel worksheet but it can still be copied to another new
workbook with content being able to be modified. How to disable this action? |
How to disable copy of protected excel worksheet?
I don't think you can.
Any attempt that I would try would rely on macros and macros can be disabled. FinishMan wrote: I protected one excel worksheet but it can still be copied to another new workbook with content being able to be modified. How to disable this action? -- Dave Peterson |
How to disable copy of protected excel worksheet?
Hello, Dave!
You wrote on Thu, 14 Sep 2006 07:52:04 -0500: DP Any attempt that I would try would rely on macros and DP macros can be disabled. DP FinishMan wrote: ?? ?? I protected one excel worksheet but it can still be copied ?? to another new workbook with content being able to be ?? modified. How to disable this action? It might depend some on what you want to do with the data. If you copied the worksheet to *Word*, the information would be visible but it would not be a spreadsheet. I could extract the data but it would be a lot of work. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
How to disable copy of protected excel worksheet?
Or just open the workbook with macros disable, unprotect the worksheet and do
whatever you want with the workbook/worksheet. James Silverton wrote: Hello, Dave! You wrote on Thu, 14 Sep 2006 07:52:04 -0500: DP Any attempt that I would try would rely on macros and DP macros can be disabled. DP FinishMan wrote: ?? ?? I protected one excel worksheet but it can still be copied ?? to another new workbook with content being able to be ?? modified. How to disable this action? It might depend some on what you want to do with the data. If you copied the worksheet to *Word*, the information would be visible but it would not be a spreadsheet. I could extract the data but it would be a lot of work. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not -- Dave Peterson |
All times are GMT +1. The time now is 05:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com