Lock Author details

Lise

unread,

Jan 7, 2010, 5:38:02 PM1/7/10

to

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
--
Thanks

Lise

Gary Keramidas

unread,

Jan 7, 2010, 5:48:48 PM1/7/10

to

not sure if it can be locked or not, but maybe you can set it in the workbook
before save procedure

ThisWorkbook.BuiltinDocumentProperties("Author").Value ="Your Name"

--

Gary Keramidas
Excel 2003

"Lise" <Li...@discussions.microsoft.com> wrote in message
news:5D95C947-82AE-448A...@microsoft.com...

Gord Dibben

unread,

Jan 7, 2010, 7:12:54 PM1/7/10

to

Why would you be doing this?

With the workbook closed I can still right-click>Properties>Summary 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 <Li...@discussions.microsoft.com>
wrote:

Gary Keramidas

unread,

Jan 7, 2010, 7:26:20 PM1/7/10

to

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
news:fbtck5tkm5nf0c5dd...@4ax.com...

Gord Dibben

unread,

Jan 7, 2010, 8:28:47 PM1/7/10

to

I don't have Windows 7

I'm still stuck on WinXP Pro

I don't use shared workbooks so have never had any workbooks with revision
numbers and change tracking.

So...........I had not noticed<g>

Gord

On Thu, 7 Jan 2010 19:26:20 -0500, "Gary Keramidas" <GKeramidasAtMSN.com>
wrote:

Gord Dibben

unread,

Jan 7, 2010, 8:44:23 PM1/7/10

to

Or did you mean Document Version which is a property Excel 2003 does not
have?

Gord

Gary Keramidas

unread,

Jan 7, 2010, 8:45:26 PM1/7/10

to

i use that field just so i can keep track of which version of a particular
workbook they're using. i display it on the title bar so the can tell me if i
suspect they have an older version.

--

Gary Keramidas
Excel 2003

"Gord Dibben" <gorddibbATshawDOTca> wrote in message

news:4b1dk5dep4708soie...@4ax.com...

Lise

unread,

Jan 7, 2010, 9:53:01 PM1/7/10

to

Thanks Gary - but where do I enter that sentence please??
--
Thanks

Lise

"Gary Keramidas" wrote:

> .
>

Gary Keramidas

unread,

Jan 7, 2010, 10:27:11 PM1/7/10

to

in the vb editor, double click thisworkbook in the project explorer, paste this
in the code window and enter the name you want to show:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

ThisWorkbook.BuiltinDocumentProperties("Author").Value ="Your Name"

End Sub

--

Gary Keramidas
Excel 2003

"Lise" <Li...@discussions.microsoft.com> wrote in message

news:33AB6E64-FBDA-4D60...@microsoft.com...