+ Reply to Thread
Results 1 to 4 of 4

Open the file only if Match Machine ID

  1. #1
    Forum Contributor nasser's Avatar
    Join Date
    12-29-2006
    Location
    Kuwait
    MS-Off Ver
    2010-2013-2016
    Posts
    216

    Open the file only if Match Machine ID

    hello, I'm looking for someway to use specific Excel file only on specific machines (3 machines), otherwise it will not work or to Display a specific message to the user.

    any help !

  2. #2
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: Open the file only if Match Machine ID

    Hi Nasser,

    You can use the below workbook_open event. However, the macro will not work until this click "Enable Macro". You can make another macro to hide all sheets so even if the users don't enable macros, they'll not be able to see anything

    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  3. #3
    Forum Contributor nasser's Avatar
    Join Date
    12-29-2006
    Location
    Kuwait
    MS-Off Ver
    2010-2013-2016
    Posts
    216

    Re: Open the file only if Match Machine ID

    Many thanks , reputation added with pleasure

  4. #4
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: Open the file only if Match Machine ID

    Glad to help & thanks for the reps "elsemey!" ... Please mark the thread as 'SOLVED' from the Thread Tool above the first post if that takes care of your original request

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to know match file in folder without open file
    By daboho in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-30-2015, 08:33 PM
  2. Listbox is resize if open in different Machine
    By ccs_1981 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2015, 05:52 AM
  3. macro to open pdf to specific page not working on different machine
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2014, 03:31 PM
  4. [SOLVED] open variably named file, copy/paste data into consolidation file, open next file in list
    By sllawrence1968 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:49 PM
  5. Replies: 7
    Last Post: 07-25-2011, 10:00 AM
  6. Error checking if file is open on different user machine
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-09-2010, 11:20 AM
  7. Replies: 6
    Last Post: 02-28-2006, 01:20 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1