Results 1 to 8 of 8
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Workbook Owner Only ? (Excel 2002/2003)

    Hi

    Am I living in fantasy land, or did I read somewhere that you can protect a workbook from being used by another company.

    I Vaguely remember it had something to do with company servers.

    Or do I need the men in White Coats <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Braddy
    If you are a fool at forty, you will always be a fool

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

    Re: Workbook Owner Only ? (Excel 2002/2003)

    You can password protect a workbook. Easily cracked, though.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Workbook Owner Only ? (Excel 2002/2003)

    Hi Hans

    Thanks for that, but I am sure that this article said it would only open if you are logged on the Company's network.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

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

    Re: Workbook Owner Only ? (Excel 2002/2003)

    I've never heard of it, and a quick Google search doesn't turn up anything relevant. Sorry.

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Workbook Owner Only ? (Excel 2002/2003)

    Hi Hans

    OK I will wait for the men in White Coats.

    Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,815
    Thanks
    132
    Thanked 480 Times in 457 Posts

    Re: Workbook Owner Only ? (Excel 2002/2003)

    Hi Braddy

    I often use VBA code to synchronise operation of a distributed workbook application suite to work within its current installed folder location.
    For example, if my workbook is accessing data from a folder named 'Input' and processing results to a folder named 'Output', I can use the
    ThisWorkbook.Path & "Input"
    ThisWorkbook.Path & "Output"
    ..to refer to these locations.
    For a company network, the path location to ThisWorkbook would typically be something like "servernamexxx..yyy..zzz"
    If the left 2 characters are NOT "" then it's usually because you are using the workbook on a local drive (e.g. C: etc)
    You could put a test for this condition in the Workbook open code.
    Similarly, you could test for a specific servername and close the workbook automatically if it didn't match your requirement.
    But what if you open the workbook with macros disabled I hear you say.
    Well, with macros disabled, the workbook won't do anything.
    ..But then you could look at the code and modify it I hear you say.
    ..so password protect the code, make all data sheets 'very hidden' as default, password protect the workbook etc.
    It would take an exceptional User (with appropriate tools) to uncover your pride of work.
    (And then of course you could use more sophisticated weapons like DLLs and add-ins to really protect it).

    I hope this is of interest.

    zeddy

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Workbook Owner Only ? (Excel 2002/2003)

    Hi Braddy,
    You can specify which users are able to edit particular ranges in a worksheet (and hence restrict it to users within a given domain) but this relies on worksheet protection, which is easily broken. Perhaps that is what you were thinking of/reading about?
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Workbook Owner Only ? (Excel 2002/2003)

    Hi

    Thanks to all who replied.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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