#1   Report Post  
Old January 7th 10, 10:38 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 102
Default Lock Author details

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

  #2   Report Post  
Old January 7th 10, 10:48 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2,494
Default Lock Author details

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

ThisWorkbook.BuiltinDocumentProperties("Author").V alue ="Your Name"


--


Gary Keramidas
Excel 2003


"Lise" wrote in message
...
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


  #3   Report Post  
Old January 8th 10, 12:12 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default Lock Author details

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


  #4   Report Post  
Old January 8th 10, 12:26 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
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



  #5   Report Post  
Old January 8th 10, 01:28 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default Lock Author details

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:

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.




  #6   Report Post  
Old January 8th 10, 01:44 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default Lock Author details

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


Gord

On Thu, 07 Jan 2010 17:28:47 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

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:

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.


  #7   Report Post  
Old January 8th 10, 01:45 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2,494
Default Lock Author details

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
...
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:

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.



  #8   Report Post  
Old January 8th 10, 02:53 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 102
Default Lock Author details

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

Lise


"Gary Keramidas" wrote:

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

ThisWorkbook.BuiltinDocumentProperties("Author").V alue ="Your Name"


--


Gary Keramidas
Excel 2003


"Lise" wrote in message
...
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


.

  #9   Report Post  
Old January 8th 10, 03:27 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2,494
Default Lock Author details

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").V alue ="Your Name"
End Sub

--


Gary Keramidas
Excel 2003


"Lise" wrote in message
...
Thanks Gary - but where do I enter that sentence please??
--
Thanks

Lise


"Gary Keramidas" wrote:

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

ThisWorkbook.BuiltinDocumentProperties("Author").V alue ="Your Name"


--


Gary Keramidas
Excel 2003


"Lise" wrote in message
...
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


.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to lock the Ctrl key? (as locking the Shift key w/Caps Lock) Rick-cel Excel Discussion (Misc queries) 2 August 5th 09 06:45 PM
Comments Author LSC Excel Discussion (Misc queries) 1 May 8th 09 05:41 PM
how do I undo the scroll lock, thscroll lock button does not work scroll lock Excel Discussion (Misc queries) 3 July 19th 08 10:17 PM
print author jiwolf Excel Worksheet Functions 1 March 15th 06 08:28 PM
adding author details to a footer dave nicholls Excel Discussion (Misc queries) 1 January 30th 06 09:41 PM


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017