Results 1 to 9 of 9

Thread: Editing Rights

  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi

    I have been asked to put an XL spreadsheet on the server as a master document and give 5 users access via a shortcut on their desktops.
    I need to restrict 3 of these users editing rights so they can read only.
    Is there a setting somewhere in options which will allow this?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='D Willett' post='763610' date='05-Mar-2009 16:19']Hi

    I have been asked to put an XL spreadsheet on the server as a master document and give 5 users access via a shortcut on their desktops.
    I need to restrict 3 of these users editing rights so they can read only.
    Is there a setting somewhere in options which will allow this?[/quote]
    You could use the /r switch in your shortcut.
    The target of the shortcut would be something like this :
    excel.exe /r "c:\My Folder\book1.xls"
    Francois

  3. #3
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Francois' date='05-Mar-2009 16:31' post='763612']
    You could use the /r switch in your shortcut.
    The target of the shortcut would be something like this :
    excel.exe /r "c:\My Folder\book1.xls"
    [/quot
    Francois. long time !
    Using the /r switch works ok but gives the user a "Save As" option which may confuse people.
    Isn't there a way to just not allow users to type anything and strictly read only ?
    Thanks for the help.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='D Willett' post='763617' date='05-Mar-2009 16:41']Using the /r switch works ok but gives the user a "Save As" option which may confuse people.
    Isn't there a way to just not allow users to type anything and strictly read only ?[/quote]

    As far as I know, no. But maybe the Excel-gurus know better
    Francois

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Hi Dave,

    Excel doesn't really provide for that.
    You could create PDF files from the workbooks and make those available to the restricted users.
    Or create an Access database with links to the Excel workbooks, and give the users a shortcut to the database. Linked Excel sheets cannot be edited in Access.

  6. #6
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Francois & Hans.

    I found this article:

    http://www.datasafexl.com/microsoft_excel_...y_tips.htm#tip5

    For other users it seems very useful.

    Thanks

  7. #7
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hans, Francois

    I've created a Macro with the following code.
    Would you mind just casting your eyes over it before I test it and ruin something.

    Private Sub CommandButton2_Click()

    Dim wSheet As Worksheet

    Select Case TextBox1.Text

    Case "BRIC"
    For Each wSheet In Worksheets
    If wSheet.ProtectContents = True Then
    wSheet.Unprotect Password:=TextBox1.Text
    Else
    wSheet.Protect Password:=TextBox1.Text
    End If

    Next wSheet
    Unload Me

    Case Else
    MsgBox "Incorrect Password", vbCritical, "Naughty Naughty !!"
    Unload Me

    End Sub

    Thanks

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Always test on a copy of the workbook!

    You may have to insert a line

    On Error Resume Next

    to avoid problems if a sheet was already unprotected when you try to unprotect it or vice versa.

    You'll want to set a password on the VBA project in the workbook, otherwise anyone who knows how to activate the Visual Basic Editor can see or even change the password.

    This protection won't keep out someone determined to get in.

  9. #9
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank You again Hans, it seems to work fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •