Password on Table or View

[Connie]

Is there a way to password protect a table or view? I have a
spreadsheet that I several people update. I have a view and table set
up for reports I need to generate. However, the other individuals
updating the schedule invariably add or hide columns to the table.
Thanks.

Connie

 

[JulieS]

Hello Connie,

I'm assuming you're talking about Project here, not Excel. Unlike
Excel, Project does not have the capabilities of "locking" ranges
nor protecting a table or view. If the user has access to the
Project file, s/he can pretty much do everything.

I hope this helps. Let us know how you get along.

Julie
Project MVP

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

"Connie" wrote in message
news:844f7224-7834-4ed3-9dab-ff0a8dba5a1e@a32g2000yqm.googlegroups.com...

 

[Jan De Messemaeker]

Hi Connie,

As Julie said, sorry, No.
But you can store your table and view in your Global.mpt file (try tools,
Organizer) and before making your report, copy them back from the Organizer
into your file.

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Connie]

Hello Connie,

I'm assuming you're talking about Project here, not Excel.  Unlike
Excel, Project does not have the capabilities of "locking" ranges
nor protecting a table or view.  If the user has access to the
Project file, s/he can pretty much do everything.

I hope this helps.  Let us know how you get along.

Julie
Project MVP

Visithttp://project.mvps.org/for the FAQs and additional
information about Microsoft Project

"Connie"  wrote in message






- Show quoted text -

Thanks. That's what I needed to know - I did not think it was
possible to password the view or table, so it's a communication issue
for me with my users not to touch my view! Thanks again!

 

[Connie]

Hi Connie,

As Julie said, sorry, No.
But you can store your table and view in your Global.mpt file (try tools,
Organizer) and before making your report, copy them back from the Organizer
into your file.

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620






- Show quoted text -

Thanks so much - that's a big help in the event my view or table is
changed!

 

[Rob Schneider]

The issue is that they touch the view/table in the MPP file. That can
be "normal" and expected. Instead of trying to prevent that, why not
make it so that it's corrected automatically. Write small macro which
upon opening the file it runs and then copies all the "untouchable"
views and tables from global.mpt into the MPP file. Helps you with
versioning sinc what's in global.mpt is the "up to date" copy.

--rms

www.rmschneider.com

 

[JulieS]

"Connie" < wrote in message

Thanks. That's what I needed to know - I did not think it was
possible to password the view or table, so it's a communication
issue
for me with my users not to touch my view! Thanks again!

You're most welcome Connie and thanks for the feedback.

Julie