Dera Mr. Randy, please help. how to secure VBA properties not just with password but with some softs. Of course i understand it could be cracked but how to secure VBA as much as possible. I guess this info will be useful for people who create their own macros and do it for sale.
Hey Randy. I know this is more advanced but is there away to use shapes with a class module and a custom event. Public withevents MyShapes as sheet1.shapes Private sub MyShapes_Click Do something End sub I don't know how to load the shapes into the class public withevents. I know how to do with active x commands. Plus how to do with userform commands. Is there away to do with shapes. I have many buttons and labels Over 100 I can get them to work. I like to use shapes if I can. Thanks.
Hi and thanks very much Dan. I have not needed to sue them with Class Modules, and also shapes do not work with userforms, only sheets. What is your overall goal with the 100 shapes? What are you trying to do or create?
@@ExcelForFreelancers I created the game minesweeper and battleship in Excel and although I have it working with active x commands. On a worksheet. I wanted to use shapes because they can be formatted a lot better than what you can do with the active x commands. I tried using a collection for the shapes and an array like I did with the active x commands but it doesn't trigger the class module custom click event.
Hi and thanks. This is a bit out of my usual comfort zone however i know an expert on this who has done amazing things, just like this. Check out www.ExcelUnusual.com His name is George Lungu and he has created many graphics and games in Excel I hope this helps and thanks so much.
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
Thank you Randy for this great content. You are so clear in your explanations and everything is so practical that I can apply it right away.
For sure, you are very welcome and I am very happy to help and share
Thank you for awesome learning
For sure, you are very welcome and I am happy to help and share
Awesome training, Thank you so much for that incredible input!
Thanks so much, I am happy to help you for sure. Thank you for your Likes, Shares & Comments. It really helps.
Great video that clearly demonstrates how to utilise one of the key tools in your toolbox.
Fantastic and thanks so much. I am happy to help and share
Thanks Randy ... Awesome training from basic to advanced and how it all fits together
Awesome Neren, thanks so much. That means a lot to me coming from you
Great job Randy, as usual. Very useful, I’m doing my own macro using all this information but also the ideas you are introducing !
That is great to hear and thanks so much. I am glad to help and share
Thank Randy, lm leaning a lot from you and the explanations are very simple.... God bless you
That is great to hear, and thanks so much for sharing. I am glad to help and share
Very helpful. Easy and detailed instructions. Thank you.
Great, thanks so much and I am really glad you enjoyed the training. Thank you for your Likes, Shares & Comments. It really helps.
Great content Randy Thank You So Much
Awesome thanks so much
Thank you for another great demonstration.
For sure, you are very welcome and thanks so much Adrian
انت الافضل.
You are the best !
👍⭐⭐⭐⭐⭐
Thank you so very much, I am really glad you enjoyed the training
Hello Randy
Hope you are doing well
Thanks so much Soheal, great to hear from you
Thank you so much Randy for this amazing video.
For sure, you are very welcome and I am happy to helps and share Syed
Supperb ❤
Thank you so very much, I really appreciate that, I am so glad you enjoyed it
Thank you SO much for sharing this video! It's absolutely fascinating and important. Truly appreciate it!
For sure, you are very welcome and I am very happy to help and share
Great content and video. You are best of the best of the best. Thank you!!!
THanks so much Tom, I am so glad I can help and share. Thank you for your Likes, Shares & Comments. It really helps.
That was an aweson training Randy, thank you very much!👏
That's great to hear and thanks so much. I am really glad you enjoyed it
Great way to highlight data for the user!
Thank you so very much, I really appreciate that
Brilliant demonstration Sir
Thank you so very much. I appreciate that
Dera Mr. Randy, please help. how to secure VBA properties not just with password but with some softs. Of course i understand it could be cracked but how to secure VBA as much as possible. I guess this info will be useful for people who create their own macros and do it for sale.
Hi and thanks very much, try xlsPadlock here:
I hope this helps and thanks so much.
Hey Randy.
I know this is more advanced but is there away to use shapes with a class module and a custom event.
Public withevents MyShapes as sheet1.shapes
Private sub MyShapes_Click
Do something
End sub
I don't know how to load the shapes into the class public withevents.
I know how to do with active x commands.
Plus how to do with userform commands.
Is there away to do with shapes.
I have many buttons and labels
Over 100 I can get them to work.
I like to use shapes if I can.
Thanks.
Hi and thanks very much Dan. I have not needed to sue them with Class Modules, and also shapes do not work with userforms, only sheets.
What is your overall goal with the 100 shapes? What are you trying to do or create?
@@ExcelForFreelancers
I created the game minesweeper and battleship in Excel and although I have it working with active x commands.
On a worksheet.
I wanted to use shapes because they can be formatted a lot better than what you can do with the active x commands.
I tried using a collection for the shapes and an array like I did with the active x commands but it doesn't trigger the class module custom click event.
Hi and thanks. This is a bit out of my usual comfort zone however i know an expert on this who has done amazing things, just like this. Check out www.ExcelUnusual.com
His name is George Lungu and he has created many graphics and games in Excel
I hope this helps and thanks so much.
@@ExcelForFreelancers
Thanks
😅👍
Thank you so very much, I really appreciate that
🤯🤯🤯😵💫😵💫😵💫🤦
Thank you so very much, I really appreciate that Gustavo