This code is great! Thank you! However, i noticed that it does not work when trying to right click inside a table. How can i modify this to work with excel tables?
Hi and thanks very much. I have not researched the context menu within tables. This is something you can research. I hope this helps and thanks so much.
@nap_boule You would need to make sure you are referencing the correct command bar type for a table. So you would need to change "application.commandbars("cell")" to the proper label for use on a table. Since a table isn't an application object, it's a sheet object, it may not work? But idk I'm still novice at this... Maybe changing "cells" to "table" would be all you need, lol
Thank you so very much, I really appreciate that, and for sure you will love this training Temyra. Thank you for your Likes, Shares & Comments. It really helps.
So if I understand the concept correctly, you can use this functionality to add right click event to a shape (rather than a cell) . Shapes by default in excel only have a click property (the OnAction call of a macro.) But you have no alternative so if you have this ability you can create a right click driven shape command button and have an alternate way of doing something when a shape is clicked , in this case by right click.)
Yes for sure Malcolm, you can experiment with any right-click event to add additional actions or macros. (i have not tried it on a shape, however its always a good idea to try new things) I hope this helps and thanks so much.
Hi and thanks so much. You can check this template out here as a good starting point: ruclips.net/video/ioro9kzW3t8/видео.html I hope this helps and thanks so much.
Hi Randy, I am having trouble downloading this workbook, BitDefender wont allow it even after I have stopped virus protection. Can you help please. Thanks.
Hi and thanks very much. I am not familiar with bit defender, however thousands of people download these templates every day. You would just have to allow this type of file and the location as a safe location. Checkf or any other antivirus or antispam applicaitons. Also, as an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
Hello Sir, I would like a hotel management application if possible. I am facing difficulties in the hotel in which I work I would be grateful to you for helping me
Hi and thanks so much. You are welcome to email me with any details Randy@ExcelForFreelancers.com Thank you for your Likes, Shares & Comments. It really helps.
😱 𝗧𝗨𝗥𝗡 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗗𝗔𝗧𝗔 𝗜𝗡𝗧𝗢 𝗦𝗜𝗠𝗣𝗟𝗘 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 𝗪𝗜𝗧𝗛 𝗔𝗜 ▶ www.excelforfreelancers.com/AiDataAnalystYTPinnedComment
Really enjoyed this one Randy! Very informative and useful. Thanks Again!!
Great, thanks so much Paul. I am very happy to help and share. Thank you for your Likes, Shares & Comments. It really helps.
very usefull lecture! thank you!!! ^^
For sure, you are very welcome and I am happy to help and share
Thank you so much Randy for this amazing video
For sure, you are very welcome and thank you so much Syed
Randy if I was a king I would knight you. You’d be sir Randy! Thank you!
Loving this Randy!
Great, thanks so much. I am so glad you enjoyed the training
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
Wow, I am truly amazed by your incredible talent! From every video I am impressed. I can't wait to see what you will do next time. Thank you so much.
Thank you so very much, I really appreciate that and this Tuesday I have a Date Picker add-in that you will love.
Thanks for new knowledge. Amazing.
For sure, you are very welcome. I am very happy I can help and share
This code is great! Thank you! However, i noticed that it does not work when trying to right click inside a table. How can i modify this to work with excel tables?
Hi and thanks very much. I have not researched the context menu within tables. This is something you can research. I hope this helps and thanks so much.
@nap_boule You would need to make sure you are referencing the correct command bar type for a table. So you would need to change "application.commandbars("cell")" to the proper label for use on a table. Since a table isn't an application object, it's a sheet object, it may not work? But idk I'm still novice at this... Maybe changing "cells" to "table" would be all you need, lol
Yes, I'm shure will be a great interesting lesson
Thank you so very much, I really appreciate that, and for sure you will love this training Temyra. Thank you for your Likes, Shares & Comments. It really helps.
So if I understand the concept correctly, you can use this functionality to add right click event to a shape (rather than a cell) . Shapes by default in excel only have a click property (the OnAction call of a macro.) But you have no alternative so if you have this ability you can create a right click driven shape command button and have an alternate way of doing something when a shape is clicked , in this case by right click.)
Yes for sure Malcolm, you can experiment with any right-click event to add additional actions or macros. (i have not tried it on a shape, however its always a good idea to try new things) I hope this helps and thanks so much.
Thanks
For sure, you are very welcome and thanks so much
Je veux une application complète de gestion hôtelière
Hi and thanks so much. You can check this template out here as a good starting point: ruclips.net/video/ioro9kzW3t8/видео.html
I hope this helps and thanks so much.
Hi Randy, I am having trouble downloading this workbook, BitDefender wont allow it even after I have stopped virus protection. Can you help please. Thanks.
All fixed Randy, sorry for messing you around.
Hi and thanks very much. I am not familiar with bit defender, however thousands of people download these templates every day. You would just have to allow this type of file and the location as a safe location. Checkf or any other antivirus or antispam applicaitons.
Also, as an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
Hello Sir, I would like a hotel management application if possible. I am facing difficulties in the hotel in which I work I would be grateful to you for helping me
Hi and thanks very much. Please check out this Hotel Manager here: ruclips.net/video/ioro9kzW3t8/видео.html
I hope this helps and thanks so much.
Your performance is genuinely outstanding! Would you like to share your thoughts on my work?🙂🙏
Hi and thanks so much. You are welcome to email me with any details Randy@ExcelForFreelancers.com
Thank you for your Likes, Shares & Comments. It really helps.