From: Bob I on 7 Apr 2010 13:26 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? >>> >>> > |