Yes prof. If you would not mind please let me have your email sir let me send you my project and you will help! I want to submit it on Friday sir please. Thanks alot
@@barderians Hi there, you can send to admin@excelvbaisfun.com if you want, and I'm happy to take a quick look, but I don't do people's homework or work for free if it's extensive. Thanks for understanding. Dan
I am quite intrigued. I would like to learn more about the XLS Padlock. Where can we take courses on this to develop an application? Please advise. Thank you in advance.
very cool! however.. do you know a work-around for scenarios where you might want to edit a different Excel sheet while the userform is open? Would this functionality even allow you to open another spreadsheet?
Hi Shady Lane, Yes, there are ways to get this functionality. You can have specific workbooks or windows to hide when you need instead of the entire application. This gets busier when you want them to be able to use the Userform OR the other workbooks as you have to make the form non-modal and then it gets busier still when you want to close the other workbook, because this seems to want to close both workbooks. There are methods we can employ to handle these, but there are some things to be aware of. Planning a mini-course to combat these struggles as we speak. :)
I was barely paying attention during the first part since I've seen that trick before, but then XLS Padlock had me salivating. Can I assume the resulting executable runs regardless of whether it's in a VBA "trusted location"? (Am guessing yes since the macro code isn't actually even there anymore.)
It does make the motw issue clear up. You still can get warnings from Microsoft until you code sign the EXE. Give the free demo a try: www.excelvbaisfun.com/xlspadlock
Hey Dan. How did you get all the extra tool commands in your toolbox. I was wonder could you do a video on making a Class module using with events. Example I'm Making a Userform With Multiple Labels and textboxes. I add them Dynamically when the Useform opens up with the Initialize event. I want to be able to use Mouse Move event and the Click event for the labels and textboxes. I Don't know how to get the with events to work properly with the Class Module. I hope You understand what i'm trying to say.
Hey Dan! The extra tools are from other ActiveX control I have, some of which are specialty control like the new Grid control I've been covering on my channel. I can send you some links! As for the class modules, ill put it on my (extensive) to-do list 🙂. Will do
Hi. This is very great tutorial and I was looking about this and found your tutorial very helpful. I have a question regarding excel VBA. Can I discuss it here or somewhere else? kindly do tell me
This code working effectively first time but second time Excel is opened
So 50/50
Thanks this helped me with my college assignment when I needed to hide the spreasheet data but need to show the form for people to interact with. :)
Thank you sir, actually am having a hard time to create something like this but you have done an amazing work here.
Hey there, thanks so much! What exactly are you having a hard time with, maybe we can help.
Thanks
Dan
It's a login page sir
@@barderians oh, I see, you're creating a login page with a Userform and trying to make it only use a Userform and suppress Excel application? Gotcha.
Yes prof. If you would not mind please let me have your email sir let me send you my project and you will help! I want to submit it on Friday sir please. Thanks alot
@@barderians Hi there, you can send to admin@excelvbaisfun.com if you want, and I'm happy to take a quick look, but I don't do people's homework or work for free if it's extensive. Thanks for understanding.
Dan
Hi. Cool option to make for a clean project load. Thanks for sharing. Thumbs up!!
Thanks, Wayne!!! I'll do another one on how to make a custom splash screen soon. It's super easy. :)
I am quite intrigued. I would like to learn more about the XLS Padlock. Where can we take courses on this to develop an application? Please advise. Thank you in advance.
Thanks Dan, amazing work.
Thanks, Eoin! I appreciate it! More to come, my friend. 😃
very cool! however.. do you know a work-around for scenarios where you might want to edit a different Excel sheet while the userform is open? Would this functionality even allow you to open another spreadsheet?
Hi Shady Lane,
Yes, there are ways to get this functionality. You can have specific workbooks or windows to hide when you need instead of the entire application. This gets busier when you want them to be able to use the Userform OR the other workbooks as you have to make the form non-modal and then it gets busier still when you want to close the other workbook, because this seems to want to close both workbooks. There are methods we can employ to handle these, but there are some things to be aware of. Planning a mini-course to combat these struggles as we speak. :)
@@ExcelVbaIsFun Application.Window(ThisWorkbook.Name).Visible = False
That will hide the window that the macro is running under
I was barely paying attention during the first part since I've seen that trick before, but then XLS Padlock had me salivating. Can I assume the resulting executable runs regardless of whether it's in a VBA "trusted location"? (Am guessing yes since the macro code isn't actually even there anymore.)
It does make the motw issue clear up. You still can get warnings from Microsoft until you code sign the EXE. Give the free demo a try: www.excelvbaisfun.com/xlspadlock
Amazing! Thanks very much
Very welcome, thomas. More to come on that topic soon
Thanks for sharing.
Very welcome, Hassan. Thanks for the comment! :)
Hey Dan. How did you get all the extra tool commands in your toolbox.
I was wonder could you do a video on making a Class module using with events.
Example
I'm Making a Userform With Multiple Labels and textboxes.
I add them Dynamically when the Useform opens up with the Initialize event.
I want to be able to use Mouse Move event and the Click event for the labels and textboxes.
I Don't know how to get the with events to work properly with the Class Module.
I hope You understand what i'm trying to say.
Hey Dan!
The extra tools are from other ActiveX control I have, some of which are specialty control like the new Grid control I've been covering on my channel. I can send you some links!
As for the class modules, ill put it on my (extensive) to-do list 🙂. Will do
Hi. This is very great tutorial and I was looking about this and found your tutorial very helpful.
I have a question regarding excel VBA. Can I discuss it here or somewhere else? kindly do tell me
Why not joining one of the many VBA forums?
Is it true that Microsoft will disable VBA for all products
Hi santosh, I answered your question in the latest episode (ua-cam.com/video/h9ROnQ2Eoyg/v-deo.html)
Thanks
Dan
When clicked on Hide (application.display = False), it closes all other open workbooks as well. How to fix this? Pls help
Same for me
please give me this application
Hi bounif, You can learn more about XLSPadlock at www.excelvbaisfun.com/lock
Pm me for a special coupon.
Thanks
Dan
No funcionó!!! :(