How do I prevent worksheet author name from being changed?

P

pennyb9

I have a coworker who likes to take credit for other people's work. How do I
prevent her from changing the author name on worksheets I have created in
Excel?
 
F

Frank Kabel

Hi
I would save the workbook with a read_only password (set this in the
saveas dialog)
 
P

pennyb9

Thank you, Frank. I guess I should have explained a little further. Another
coworker and I create shared spreadsheets for several of us in the department
to use, so it can't be a read only sheet. I just want to keep the one
coworker from changing the author name on the properties tab to her own name.
Is this possible? I've looked through dozens of help files and topics to no
avail. Seems like it should be a simple thing to do?

Thanks again.
 
F

Frank Kabel

Hi
if she has access to the file (to change cells for example) no way
AFAIK to prevent changing the file properties
 
G

Gord Dibben

penny

Is this just a p..sing contest or do you stand to lose money and/or chance for
promotion due to the coworker's actions?

A talk to the boss with coworker present may be in order.

Gord Dibben Excel MVP
 
Top