| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| allow me to copy and paste in a protected worksheet | New Users to Excel | |||
| adjusting decimal place in protected worksheet in excel 2007 | Excel Worksheet Functions | |||
| How can I do a "Save As" on a protected excel worksheet | Excel Worksheet Functions | |||
| Change position of move or copy worksheet option in Excel | Excel Discussion (Misc queries) | |||
| why can't excel do a simple find and copy row from a worksheet to. | Excel Worksheet Functions | |||
Linear Mode
