View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default Lock Author details


gord:

have you noticed that in windows 7, you can't change the revision number on the
details tab by right clicking an xls file?
i constantly have to rename them to a 2007+ extension (xlsm) to expose that box.

--

Gary Keramidas
Excel 2003


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Why would you be doing this?

With the workbook closed I can still right-clickPropertiesSummary and
change the Author Name if I wanted to steal and distribute the workbook as
my creation.

Assuming I have full permissions to make changes to files and folders.

If users have restricted permissions then I think Gary's beforesave code
will do the job.

But will be defeated if macros are disabled by users.


Gord Dibben MS Excel MVP


On Thu, 7 Jan 2010 14:38:02 -0800, Lise
wrote:

Hi there

Is there a way to lock the author details found in properties? I don't want
other users to be able to change this but at the same time don't want to have
to password protect the whole sheet.

Any help as always appreciated