Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Block a excel file from being copied?
I am trying to stop others from saving a file under a different name. Is it
possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Block a excel file from being copied?
Not really.
Users can copy the file using windows explorer. And anything I could do to make sure that it's where it's supposed to be (and named correctly) would rely on macros. And macros can be disabled. SG Hurst wrote: I am trying to stop others from saving a file under a different name. Is it possible? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Block a excel file from being copied?
Perhaps "hide" everything in the file, and then have auto-open macro
check file name and location, if success, unhide? Dave Peterson wrote: Not really. Users can copy the file using windows explorer. And anything I could do to make sure that it's where it's supposed to be (and named correctly) would rely on macros. And macros can be disabled. SG Hurst wrote: I am trying to stop others from saving a file under a different name. Is it possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Block a excel file from being copied?
Perhaps...
But if the user has to update the file and then save it, you'd have to complicate matters (a whole lot) by saving the file with all that stuff hidden. And with the protection that's offered by both worksheet and workbook protection (tools|protection type), it's still not too secure. Bob I wrote: Perhaps "hide" everything in the file, and then have auto-open macro check file name and location, if success, unhide? Dave Peterson wrote: Not really. Users can copy the file using windows explorer. And anything I could do to make sure that it's where it's supposed to be (and named correctly) would rely on macros. And macros can be disabled. SG Hurst wrote: I am trying to stop others from saving a file under a different name. Is it possible? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Block a excel file from being copied?
Saving, copying and everything else to do with storing or deleting files is
handled by your operating system. XL really has no say in the matter. -- HTH... Jim Thomlinson "SG Hurst" wrote: I am trying to stop others from saving a file under a different name. Is it possible? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Block a excel file from being copied?
It definitely would be messy, I guess it depends on the situation the OP
is attempting to "cure". Dave Peterson wrote: Perhaps... But if the user has to update the file and then save it, you'd have to complicate matters (a whole lot) by saving the file with all that stuff hidden. And with the protection that's offered by both worksheet and workbook protection (tools|protection type), it's still not too secure. Bob I wrote: Perhaps "hide" everything in the file, and then have auto-open macro check file name and location, if success, unhide? Dave Peterson wrote: Not really. Users can copy the file using windows explorer. And anything I could do to make sure that it's where it's supposed to be (and named correctly) would rely on macros. And macros can be disabled. SG Hurst wrote: I am trying to stop others from saving a file under a different name. Is it possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I block users to save the excel file if conditions not met | Excel Discussion (Misc queries) | |||
HOW DO I AUTO NAME A SAVED FILE FROM A SPEC. BLOCK IN EXCEL? | Excel Discussion (Misc queries) | |||
Copied Over My Previous MS Excel File | Excel Discussion (Misc queries) | |||
Block a file in Excel from being emailed through Outlook | Excel Discussion (Misc queries) | |||
Excel file 4MB.Copied sheets to a new file.Now=64Kb-easier way? | Excel Discussion (Misc queries) |