+ Reply to Thread
Results 1 to 3 of 3

is possible user form just only lock the current workbook?

Hybrid View

  1. #1
    Registered User
    Join Date
    05-21-2018
    Location
    Malaysia
    MS-Off Ver
    2016
    Posts
    94

    is possible user form just only lock the current workbook?

    i have open 2 excel but when i run the user form it will block both content , i just want to block current workbook content only.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,816

    Re: is possible user form just only lock the current workbook?

    I think I understand what you mean, and if so, I suspect it is because the user form is a modal dialog (a bit like the one that comes up when you launch PowerQuery). This means that you can only interact with that window in Excel whilst ever it's open, and I doubt, therefore, that there is a workaround, as I believe this is a Windows level feature.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: is possible user form just only lock the current workbook?

    What do you mean by 'block'.

    Try setting your userform ShowModal modal property to false. A macro can selectively do stuff, like switching on sheet protection' with one workbook but not the other. If your workbook has macros that address both workbooks then change it so that it only addresses one of them. Difficult to comment further without seeing the workbook.
    Last edited by Richard Buttrey; 07-06-2018 at 03:39 AM.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Lock following cells form user input and colour the same with grey.
    By Aristotle Exclaims in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-03-2017, 11:19 AM
  2. Lock following cells form user input and colour the same with grey.
    By Aristotle Exclaims in forum Excel General
    Replies: 0
    Last Post: 09-03-2017, 11:19 AM
  3. Populate user form with current data
    By Tmay333 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2013, 03:02 PM
  4. Find text on current user form
    By KAPearson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2012, 08:27 AM
  5. Lock and Grey Out Options on a User Form
    By laffers in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-07-2011, 08:31 PM
  6. Current User who has Workbook Locked
    By mozart in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2007, 06:32 AM
  7. Forcing user's to use the most current workbook!
    By patele in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2006, 06:39 AM

Tags for this Thread

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