Greeting Message in mpp File

[TKS_Mark]

We have to share our shedules regularly with the customer and subs. But now,
the schedules include manpower w/ rates and material. This information is
confidential. We have changed the filename to "confidential", but we are
scared that someone will accidentally provide one of our many schedules to a
customer, sub or competitor without knowing how confidential.

I want to make a greeting message that says something like, "Confidential
Info. Do Not Share this files Outside of our Company!".

Is there a way to make this come up no matter which view was saved last?

 

[John]

We have to share our shedules regularly with the customer and subs. But now,
the schedules include manpower w/ rates and material. This information is
confidential. We have changed the filename to "confidential", but we are
scared that someone will accidentally provide one of our many schedules to a
customer, sub or competitor without knowing how confidential.

I want to make a greeting message that says something like, "Confidential
Info. Do Not Share this files Outside of our Company!".

Is there a way to make this come up no matter which view was saved last?

TKS_Mark,
You can create a Open Even macro that will provide the warning you
describe. However, unless users have their Project macro security level
set to medium or lower, or unless you go through the process of setting
up a digital certificate, then the Open Even message will never appear.
Therefore your best line of defense is training, training and more
training on company security.

Nonetheless for reference the following Open Even macro will do what you
need. Just follow the steps on each user's PC. If you have an enterprise
Global, it can probably be done using that.
1. Go to Tools/Macro/VB Editor
2. Hit the Project Explorer button on the standard VB Editor toolbar
3. If necessary scroll to the ProjectGlobal (Global.MPT).
4. Double click on the ThisProject (Global.MPT)
5. Insert the following code into the code window
6. Go to File/Save Global.MPT

Private Sub Project_Open(ByVal pj As MSProject.Project)
MsgBox "WARNING - the data you are about to view is company private." &
vbCr & _
"This file and the data it contains shall not be shared with" & vbCr
& _
"anyone outside of [your company name]. This includes all " & vbCr &
_
"customers, suppliers, individuals or corporate entities.",
vbCritical, "SECURITY WARNING"
End Sub

Good luck,
John
Project MVP

 

[Jack Dahlgren]

The macro limitation is true... they may not see it, so you could password
protect the file then they will have no choice. Make the password something
like "Confidential_do_not_share"...

--
Jack Dahlgren
Project Blog: http://zo-d.com/blog
Macros: http://masamiki.com/project/macros.htm
"docendo discimus"

We have to share our shedules regularly with the customer and subs. But
now,
the schedules include manpower w/ rates and material. This information
is
confidential. We have changed the filename to "confidential", but we are
scared that someone will accidentally provide one of our many schedules
to a
customer, sub or competitor without knowing how confidential.

I want to make a greeting message that says something like, "Confidential
Info. Do Not Share this files Outside of our Company!".

Is there a way to make this come up no matter which view was saved last?

TKS_Mark,
You can create a Open Even macro that will provide the warning you
describe. However, unless users have their Project macro security level
set to medium or lower, or unless you go through the process of setting
up a digital certificate, then the Open Even message will never appear.
Therefore your best line of defense is training, training and more
training on company security.

Nonetheless for reference the following Open Even macro will do what you
need. Just follow the steps on each user's PC. If you have an enterprise
Global, it can probably be done using that.
1. Go to Tools/Macro/VB Editor
2. Hit the Project Explorer button on the standard VB Editor toolbar
3. If necessary scroll to the ProjectGlobal (Global.MPT).
4. Double click on the ThisProject (Global.MPT)
5. Insert the following code into the code window
6. Go to File/Save Global.MPT

Private Sub Project_Open(ByVal pj As MSProject.Project)
MsgBox "WARNING - the data you are about to view is company private." &
vbCr & _
"This file and the data it contains shall not be shared with" & vbCr
& _
"anyone outside of [your company name]. This includes all " & vbCr &
_
"customers, suppliers, individuals or corporate entities.",
vbCritical, "SECURITY WARNING"
End Sub

Good luck,
John
Project MVP

 

[Jim Aksel]

Although your greeting message may deter most honest users, your are still
giving your data away. Do your customers and subs have a requirement to see
this cost data? Are your required to submit the data in mpp format?

Consider a Macro that will change all cost data to $.00, all labor hour to
0.0 (you will need to change task types to fixed duation prior to doing
that). You might even want to consider a macro that will clear out all
resources since even resource assignments may give away trade secrets or your
methods of accomplishing the work. Run the macro prior to giving away your
data.

Consider agreeing with your customers/subs what views they need to see and
what inforamtion they need to have. Create such a view and publish the file
in pdf format using a pdf writer (such as acrobat).

Inmost instances, I think you will find that all the subs need are a few key
dates.


--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[TKS_Mark]

John,

Thanks for your reply. I installed the macro as described below. But I
could only get it to work on global.mpt, not on the actual project file. How
to I install it into an actual existing project file?

Thanks,

Mark.

We have to share our shedules regularly with the customer and subs. But now,
the schedules include manpower w/ rates and material. This information is
confidential. We have changed the filename to "confidential", but we are
scared that someone will accidentally provide one of our many schedules to a
customer, sub or competitor without knowing how confidential.

I want to make a greeting message that says something like, "Confidential
Info. Do Not Share this files Outside of our Company!".

Is there a way to make this come up no matter which view was saved last?

TKS_Mark,
You can create a Open Even macro that will provide the warning you
describe. However, unless users have their Project macro security level
set to medium or lower, or unless you go through the process of setting
up a digital certificate, then the Open Even message will never appear.
Therefore your best line of defense is training, training and more
training on company security.

Nonetheless for reference the following Open Even macro will do what you
need. Just follow the steps on each user's PC. If you have an enterprise
Global, it can probably be done using that.
1. Go to Tools/Macro/VB Editor
2. Hit the Project Explorer button on the standard VB Editor toolbar
3. If necessary scroll to the ProjectGlobal (Global.MPT).
4. Double click on the ThisProject (Global.MPT)
5. Insert the following code into the code window
6. Go to File/Save Global.MPT

Private Sub Project_Open(ByVal pj As MSProject.Project)
MsgBox "WARNING - the data you are about to view is company private." &
vbCr & _
"This file and the data it contains shall not be shared with" & vbCr
& _
"anyone outside of [your company name]. This includes all " & vbCr &
_
"customers, suppliers, individuals or corporate entities.",
vbCritical, "SECURITY WARNING"
End Sub

Good luck,
John
Project MVP

 

[TKS_Mark]

Jim,

Can you provide an example of this code? I would like to try it. We
usually manually do what you are describing.

Thanks,

TKSMark.

 

[John]

John,

Thanks for your reply. I installed the macro as described below. But I
could only get it to work on global.mpt, not on the actual project file. How
to I install it into an actual existing project file?

Thanks,

Mark

Mark,
If you installed it into your Global, it will activate for any project
file that is opened. Nonetheless, if you want to install it in each
individual file, at step 4 (in my previous post), substitute
ThisProject (your file name).

Hope this helps.
John

We have to share our shedules regularly with the customer and subs. But
now,
the schedules include manpower w/ rates and material. This information
is
confidential. We have changed the filename to "confidential", but we are
scared that someone will accidentally provide one of our many schedules
to a
customer, sub or competitor without knowing how confidential.

I want to make a greeting message that says something like, "Confidential
Info. Do Not Share this files Outside of our Company!".

Is there a way to make this come up no matter which view was saved last?

TKS_Mark,
You can create a Open Even macro that will provide the warning you
describe. However, unless users have their Project macro security level
set to medium or lower, or unless you go through the process of setting
up a digital certificate, then the Open Even message will never appear.
Therefore your best line of defense is training, training and more
training on company security.

Nonetheless for reference the following Open Even macro will do what you
need. Just follow the steps on each user's PC. If you have an enterprise
Global, it can probably be done using that.
1. Go to Tools/Macro/VB Editor
2. Hit the Project Explorer button on the standard VB Editor toolbar
3. If necessary scroll to the ProjectGlobal (Global.MPT).
4. Double click on the ThisProject (Global.MPT)
5. Insert the following code into the code window
6. Go to File/Save Global.MPT

Private Sub Project_Open(ByVal pj As MSProject.Project)
MsgBox "WARNING - the data you are about to view is company private." &
vbCr & _
"This file and the data it contains shall not be shared with" & vbCr
& _
"anyone outside of [your company name]. This includes all " & vbCr &
_
"customers, suppliers, individuals or corporate entities.",
vbCritical, "SECURITY WARNING"
End Sub

Good luck,
John
Project MVP

 

[TKS_Mark]

John,

I originally had changed step 4 to ThisProject (my file name). However,
when I close Project and then open this file, I don't receive the message,
even though I can check that the macro is indeed there.

Mark.

John,

Thanks for your reply. I installed the macro as described below. But I
could only get it to work on global.mpt, not on the actual project file. How
to I install it into an actual existing project file?

Thanks,

Mark

Mark,
If you installed it into your Global, it will activate for any project
file that is opened. Nonetheless, if you want to install it in each
individual file, at step 4 (in my previous post), substitute
ThisProject (your file name).

Hope this helps.
John

We have to share our shedules regularly with the customer and subs. But
now,
the schedules include manpower w/ rates and material. This information
is
confidential. We have changed the filename to "confidential", but we are
scared that someone will accidentally provide one of our many schedules
to a
customer, sub or competitor without knowing how confidential.

I want to make a greeting message that says something like, "Confidential
Info. Do Not Share this files Outside of our Company!".

Is there a way to make this come up no matter which view was saved last?

TKS_Mark,
You can create a Open Even macro that will provide the warning you
describe. However, unless users have their Project macro security level
set to medium or lower, or unless you go through the process of setting
up a digital certificate, then the Open Even message will never appear.
Therefore your best line of defense is training, training and more
training on company security.

Nonetheless for reference the following Open Even macro will do what you
need. Just follow the steps on each user's PC. If you have an enterprise
Global, it can probably be done using that.
1. Go to Tools/Macro/VB Editor
2. Hit the Project Explorer button on the standard VB Editor toolbar
3. If necessary scroll to the ProjectGlobal (Global.MPT).
4. Double click on the ThisProject (Global.MPT)
5. Insert the following code into the code window
6. Go to File/Save Global.MPT

Private Sub Project_Open(ByVal pj As MSProject.Project)
MsgBox "WARNING - the data you are about to view is company private." &
vbCr & _
"This file and the data it contains shall not be shared with" & vbCr
& _
"anyone outside of [your company name]. This includes all " & vbCr &
_
"customers, suppliers, individuals or corporate entities.",
vbCritical, "SECURITY WARNING"
End Sub

Good luck,
John
Project MVP

 

[John]

John,

I originally had changed step 4 to ThisProject (my file name). However,
when I close Project and then open this file, I don't receive the message,
even though I can check that the macro is indeed there.

Mark.

Mark,
OK, that probably means the security level for running macros is set to
high or very high. Remember in my first response I cited that as a
disadvantage of using an Open Even macro (i.e. its pretty easy to
disable it from running).

John

John,

Thanks for your reply. I installed the macro as described below. But I
could only get it to work on global.mpt, not on the actual project file.
How
to I install it into an actual existing project file?

Thanks,

Mark

Mark,
If you installed it into your Global, it will activate for any project
file that is opened. Nonetheless, if you want to install it in each
individual file, at step 4 (in my previous post), substitute
ThisProject (your file name).

Hope this helps.
John

:

We have to share our shedules regularly with the customer and subs.
But
now,
the schedules include manpower w/ rates and material. This
information
is
confidential. We have changed the filename to "confidential", but we
are
scared that someone will accidentally provide one of our many
schedules
to a
customer, sub or competitor without knowing how confidential.

I want to make a greeting message that says something like,
"Confidential
Info. Do Not Share this files Outside of our Company!".

Is there a way to make this come up no matter which view was saved
last?

TKS_Mark,
You can create a Open Even macro that will provide the warning you
describe. However, unless users have their Project macro security level
set to medium or lower, or unless you go through the process of setting
up a digital certificate, then the Open Even message will never appear.
Therefore your best line of defense is training, training and more
training on company security.

Nonetheless for reference the following Open Even macro will do what
you
need. Just follow the steps on each user's PC. If you have an
enterprise
Global, it can probably be done using that.
1. Go to Tools/Macro/VB Editor
2. Hit the Project Explorer button on the standard VB Editor toolbar
3. If necessary scroll to the ProjectGlobal (Global.MPT).
4. Double click on the ThisProject (Global.MPT)
5. Insert the following code into the code window
6. Go to File/Save Global.MPT

Private Sub Project_Open(ByVal pj As MSProject.Project)
MsgBox "WARNING - the data you are about to view is company private." &
vbCr & _
"This file and the data it contains shall not be shared with" &
vbCr
& _
"anyone outside of [your company name]. This includes all " & vbCr
&
_
"customers, suppliers, individuals or corporate entities.",
vbCritical, "SECURITY WARNING"
End Sub

Good luck,
John
Project MVP