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.
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.
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.
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 iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks