Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to lock the Ctrl key? (as locking the Shift key w/Caps Lock) | Excel Discussion (Misc queries) | |||
Comments Author | Excel Discussion (Misc queries) | |||
how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
print author | Excel Worksheet Functions | |||
adding author details to a footer | Excel Discussion (Misc queries) |