automatic removing of sensible data in msp 1

[asdasdasd123]

hi,

we are scheduling msp - plans with the belonging workload and the needed resources. Our customers request the timetable as msp file to make their own adjustments. As we dont want, that our custoemrs get all the information about the resources, but just the timetable, we are looking how we could cut this information out.

So far we do that through deleting these rows.
my question is, if there is an automatic way to delete these rows to secure, that we cannot forget it, before we send it out. Or maybe there is even another way to hide these.

thx a lot, rgds amanda

 

[PDQBach]

MS Project is designed in such a way that if you can open the file you can see *all* the data. There is no way to lock some data away from viewing. (You can hide columns but that doesn't lock it away. You can remove views but they can be recreated.)

You have five options:

* Create an export map including various filters. It will take a while to tweak so that you are exporting only the data you want to export. (You will not be able to export the "structure" of the project when you export Tasks.)

* Write some VBA that will export selected data from your existing project into a blank project. (VBA is flexible, powerful and somewhat time-consuming if you are not used to writing macros.)

* Write some VBA that will "sanitize" your existing project and save it under a new name.

* Write some VBA to export selected data to an Excel spreadsheet

* Copy&Paste into Excel

Of course, this means you will also need to have some way to indicate any updates on the files that come back from the others in the group (whether they are Excel spreadsheets or sanitized Project files).

 

[johnherman]

Nice post, thanks PDQ

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright