Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    OnOpen based on mac address (2003)

    I am wanting to know if and how to only open a file base on a mac address?

    thanks,
    jackal

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

    Re: OnOpen based on mac address (2003)

    See Determining a Local MAC Address via NetBIOS for code to obtain the MAC address of the computer.

    You could set the Visible property of all worksheets except one with a copyright notice to xlSheetVeryHidden. In the Workbook_Open event, use the above code to check the MAC address. If it is OK, unhide some or all of the sheets, otherwise close the workbook. If the user disables macros, the sheets will remain hidden, so the user can't do anything useful with the workbook. Set a password on the VBA project.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: OnOpen based on mac address (2003)

    I am not sure what part, if not all of the code I need to use to look at the MAC address and if it is <> to some MAC address(00-00-00-00-00-00) then close workbook.

    thanks
    jackal

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

    Re: OnOpen based on mac address (2003)

    Me neither. I just posted a link to code related to MAC addresses.

Posting Permissions

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