Block a excel file from being copied?
in [General]
|
From: SG Hurst SG on 7 Apr 2010 08:04 I am trying to stop others from saving a file under a different name. Is it possible?
From: Dave Peterson on 7 Apr 2010 08:59 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
From: Bob I on 7 Apr 2010 09:41 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? > >
From: Dave Peterson on 7 Apr 2010 09:48 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
From: Jim Thomlinson on 7 Apr 2010 09:52
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? |