I've watched all your videos and learned a lot, thanks to you I'm not exaggerating. I am very grateful. There are not many people like you who share his talents with the whole world for free. Your knowledge amazes everyone with your talents and with enthusiasm. You are an endless source of inspiration. Good luck to everyone learning to code. As always impatiently awaiting this instructive video. Good health and happiness dear Randy
Hi Randy ... WOW these are some super awesome features and thanks for the reminder as I have not used some of these in a long time. Very useful and inspirational. Thank you Randy
Thank you so very much Neren. I appreciate that and I am glad you were able to get a lot of value from it. Thank you for your Likes, Shares & Comments. It really helps.
Very useful video. Many good tips about protection grouped so it's easy to pick those that you want to use in your own spreadsheet. Excellent instructor.
For sure, you are very welcome and happy to help. This one was a big complex for beginners but last Tuesday i had a great one for beginners here: th-cam.com/video/hv3I-4L-hWk/w-d-xo.html I hope this helps and thanks so much.
Randy, thanks for this, I know it is going to be a good one, knowing how you do your training, looking forward to this one as it is very needed for excel programmers. Can wait. Going to go sleep early every night so next week can come quick. Hope you'll cover how to not allow people to copy your work to different workbooks, this is what I'm struggling with. They copy your work to different workbook and have access to all your hard work. Thanks much appreciated. If you can show how to prevent copying you worksheets but allow people to paste information in the tool. I know this is a long message ,but I'm just super excited, please can you cover hiw to make your vba code unviewable the proper way and the request above regarding the copying .
HI and thanks so much. Yes certainly I will cover that, as I show you how to tie Excel to a specific machine, and disable the save as, and hiding the VBA code. Everything will be covered in this single training. I hope this helps and thanks so much.
Brilliant, Brilliant, Brilliant, more than I expected, even cover what I was asking for. One question Randy, the machine ID, if I have a sheet outside of the application that I have a list of machine and I want the application to check if the machine is in the list and if so allow access else close application. Your response will be much appreciated
Hi and thanks you can open the sheet within VBA and then use the FInd command to check if the file # is within the list or not. I hope this helps and thanks so much.
Hey Randy, First off, I just want to say I'm a huge fan of your videos. The amount of work and dedication you put into explaining complex topics is truly commendable. However, I've been doing some digging, and it seems like everything you're explaining about protecting spreadsheets can be cracked in less than a minute. I'm pretty sure you're aware that the standard methods like password protect, structure protect, and VBA project password protect, unfortunately, can be hacked and cracked under five minutes, for free. Do you happen to know of any unconventional or more robust ways to protect spreadsheets? Such as protecting the codes though add-ins? I'd love to hear your insights on this matter. Keep up the great work, looking forward to your next video
Hi and thanks for your comment I am so glad you enjoy the training. If you want to go beyond Excel's own security you can try a product like XLSPadlock bit.ly/SecureExcel I hope this helps and thanks so much.
Hi Sir. Good Day! It is very informative to watch your videos. I am learning a lot. I would like to ask if it is possible to lock excel workbook in a single storage (like USB) using serial number and if copied to other storage if excel will automatically close once opened?
Hey Randy, thx for the great Video, I have one Question about the Loing Process for the Users. Why are you not using the current UserName from the Microsoft Account? I was trying to do that. Because then you do not have to generate a Password for the Users. What is your opinion on that
HI and thanks very much. Many users and admin prefer to assign their own users and passwords, separately from their Microsoft usernames and passwords. Also I like to have my templates available for even very old versions of Excel in which the Microsoft username does not exist. This way, these templates and applications are fully backward compatible. Admins also have the ability to revoke access to end users. I hope this helps and thanks so much.
Hi Randy, hope you are well, thanks again for the training, it is brilliant, I'm hoping you can help me, I like the disablement of the copy cut paste, however, I need to disable the copy cut, but allow the user to paste data from a report that they pull for the business system, I tried playing around with the code that you provided in the training. Can't seem to get it to work, I also been looking on the internet but can't find anything that can help me, I can copy the work from another source but it doesn't allow me to paste. Hope you can help, thanks again for all your training, I really appreciate the time , effort and knowledge you out in to do the training with us, yiur channel is the best out there.
HI and thanks so much. You can activate the Paste by setting a few of the values to True, within the macros. It would be difficult to say exactly where, since i can't put all of the code inside a TH-cam response, however if you need help with this I would be happy to refer you to a qualified developer (Randy@ExcelForFreelancers.com ) I hope this helps and thanks so much.
HI Keith it may be possible however i have just used 3rd party software to do it, so i am really not sure without. I hope this helps and thanks so much.
HI and thanks. yes this will work just fine, so no problem. Just make sure to unprotect any cells in which you want the end-user to modify. I hope this helps and thanks so much.
Hello Randy, just have a quick question. Have you created any videos on User interface on VBA? I meant to say like an application where the data is getting stored in the excel file but the user see all that info in the form on user interface, instead of excel?
Hi and thanks very much for your feedback. The term 'User Interface' generally means what the user sees, So almost every one of my videos has a user interface in which the user sees and works with, while the database is generally hidden. Excel can be manipulated and coded so this is all that is needed and not any other outside application. All that is required is the desktop version of Microsoft Excel. I hope this helps and thanks so much.
Hi Sir , Thank you very much for this video. Please, would mind sending the code vba to get Mac Machine Id. It's not clear to note in the video. Thank you very much.
Hi Claude, Thanks so much. You can download this file using the links in the description under the word DOWNLOAD. This should work for hte Mac's as well. I hope this helps and thanks.
Hi and thanks. Digital signatures can be helpful, however they may not solve all issues. I can understand the challenges, and now with the added security, however, i just created a page to help people activate macros, and just send them there. It has not been too much of a stumbling block. Here is the page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
As always it's an awesome video. Quick question, if I subscribe to your patreon, would I be able to download the updated Dynamic userform example file as you mentioned in a past video including the delete and update buttons ? Thanks again Randy
Hi and thanks so much. Yes you would, I do have that updated training and download available for our Silver and Gold Patrons. I hope this helps and thanks so much.
great job, but I have one question. how can we protect the final executable code to be reused on just one machine...in other to avoid people to give the same executable to their friend . executable should be used by the client only...he should not be able to share it. how can we do that ? thank you🙏
Hi and thanks. You can write your unique code to that computers registry on registration. Then each day check to make sure the computer in which the application is on matches the registry ID. This will ensure that only one computer is used per registration. I hope this helps and thanks so much. In the near future I will be creating an entire course on how to secure & license your Excel-based application & Addin to help answer all of these questions. Thank you for your Likes, Shares & Comments. It really helps.
My users can open the spreadsheets on SharePoint both in Excel Online and Desktop app. I don't see how I can prevent the spreadsheets to be opened in Excel Online and then the macros don't work. Is there a way to enforce use of Desktop app when files are stored on SharePoint? Is the solution to use OfficeScript instead? (of which I know much less than VBA, so I would like to avoid OfficeScript)
Hi Joe, thanks for your message. I do not have a lot of experience with Sharepoint, however, if you simply want to share the files, why not use a Shared folder such as the Free Dropbox. I have been using it for years without issue. Concerning the answer, I put it through ChatGPT since I don't have Sharepoint set up here, and here is what ChatGPT came up with: "As of my last update, directly enforcing the opening of Excel files with macros in the desktop application when they are stored on SharePoint or OneDrive is not straightforward due to the limitations in the way Microsoft handles file access via SharePoint and OneDrive web interfaces. Excel Online does not support the execution of macros, which can be a significant limitation if your workflows depend heavily on VBA scripts. However, there are a few strategies and best practices you can consider to guide your users towards using the Excel desktop application: Educate Users: Sometimes the simplest and most effective strategy is to ensure that your users are aware of the limitations of Excel Online, especially regarding macros. Inform them that they need to open certain files in the Excel desktop app to ensure full functionality. This can be done through training sessions, emails, or popup messages within the organization. Use Workbook Open Event: You can include VBA code that checks if the workbook is opened in Excel Online. While you can't force it to close or switch directly to the desktop application, you can display a message instructing the user to open the file in the desktop version of Excel. Here's an example of how you might set up such a VBA script: VBA CODE: Private Sub Workbook_Open() If Application.Online = True Then MsgBox "This workbook contains macros and must be opened in the Excel desktop application for full functionality.", vbCritical ' Optionally, you could close the workbook ' ThisWorkbook.Close False End If End Sub File Naming Conventions: Use file naming conventions to indicate that a file contains macros and should be opened with the desktop application. For example, prefixing file names with "MACRO-ENABLED-" could alert users to the need for the desktop app. SharePoint and OneDrive Configuration: If possible, adjust SharePoint or OneDrive settings to favor opening files in the desktop app. However, this is typically limited to global settings that affect all documents, which may not be desirable. Distribute Desktop Shortcuts: For key documents, provide users with desktop shortcuts that open the Excel files directly in the desktop application. This method bypasses the web interface, reducing the chance that users will inadvertently open the file in Excel Online. Advanced Techniques: For organizations with access to advanced IT resources, you could explore using group policies or developing a custom solution that integrates with SharePoint to enforce opening certain files with desktop apps. These solutions would likely involve significant customization and IT involvement. Check Access Type: If feasible, use the Excel capability to check how the workbook is being accessed and provide feedback or restrictions: VBA CODE: If Not Application.CommandBars("Workbook tabs").Enabled Then MsgBox "This workbook is viewed in a browser (Excel Online) and will not function correctly. Please open it in Microsoft Excel on your desktop.", vbExclamation ThisWorkbook.Close savechanges:=False End If While none of these methods are foolproof or can enforce the opening strictly in the desktop app without user compliance, they can help manage and guide user behavior more effectively."
Hi Randy, hope you well. I built an application where I use the protection code, downloaded the UI editor, works fine on my laptop, however, I saved the workbook on a share drive and it still works for, but when my colleagues open the workbook it's says the that macro is not working so they are able to use the copy and paste using the toolbar ribbon. Hiw do I get it to apply on their laptops. Thank you so much.
Hi and thanks. As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can have your friends 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/ Have them follow step # 2 I hope this helps and thanks so much.
Dear Sir, please make a full course on creating Excel Application from which we can sell our services on freelance market. Please sir kindly make it happen. Thanks
HI and thanks very much. I do have that already in my Mentorship course here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
Hi and thanks for that. There is a simple fix for that and I have outlined it here on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
@@ExcelForFreelancers i already know this sir. But this is very hastle when selling an excel application. Because not every buyer knows how to do it even if you give them an instruction or video instruction. Very hastle.
Hi and thanks for your comment. I suggest using a shared & backed up folder such as Dropbox, OneDrive or Google Drive. This way you have a saved version online so you can revert back to any version you want in case of mishap. I hope this helps and thanks so much.
Another problem I use active x a lot in my file when computer update I lost all my listbox active x and remain active x became picture Do use know how to prevent it???.
Hi and thanks very much. I had not heard of that issue, however if you are using a Mac I know they do not run Activex. With a WIndows PC, an update should never affect most Activex controls. I hope this helps and thanks so much.
Hi and thanks very much. Activex controls do not work on Macs. Mac's have a very limited feature set when it comes to working with Excel VBA. You may want to consider using Parallels which will mimic the PC environment on your Mac. I hope this helps and thanks so much.
HI and thanks for your message. Yes, since the range is dynamic, it will grow as the data grows, and remain password protected. I hope this helps and thanks so much.
Hi there, question! when you send a new app to a paid customer, then its waiting to be registered and the app pulls the machine ID into the app and you send them their Lic.Key. well what will happen if they take the original app(which you emailed) and open it on a new machine and put in the same Lic.Key? because the original app machine ID is blank...
Hi and thanks for your question. When they originally register it their machine ID is saved in a secure location. Each time the app is opened, used or at regular intervals, the machine ID is checked that the current machine ID is the same as the one saved in the secure location. If the ID's are different then we know that this is not the original machine and a user can be restricted. I hope this helps and thanks so much.
Thanks for your reply, but how are we to know or check their ID if they have the App? as the registration does not send us that information(Machine ID)@@ExcelForFreelancers
Hi Billy, thanks for your question. I share that with you in this training: th-cam.com/video/l-tgyQvdC5g/w-d-xo.html I hope this helps and thanks so much.
@@ExcelForFreelancers Hi, Randy ! The XML code template is missing in the link file in "CutCopyPaste_Macros" module. More details here 38:20. About me, it's ok, I typed that XML code snippet manually, it's small. It's okay!
Ah now I understand. Actually, you don't need to retype it. Yes you are right the xml code is not inside the module, but it is inside the workbook. So first you would download the Free Office RibbonX Editor, then you would open the workbook with the editor, and inside there, you will find all the xml code (here is a screenshot www.dropbox.com/scl/fi/9dv11s1xx9r2v5hue0gwb/XML_Code.png?rlkey=iemazyoxfy4pwenwokez6wnou&dl=0 I hope this helps and thanks so much.
![Learn How To Create Your First Custom Ribbon Toolbar In Excel [Free Download]](/img/n.gif)
😱 𝗨𝗡𝗕𝗘𝗟𝗜𝗘𝗩𝗔𝗕𝗟𝗘 𝟲𝟱% 𝗢𝗙𝗙 𝗧𝗛𝗜𝗦 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬! 👉 www.excelforfreelancers.com/BFSale2024_YTPinnedComm
I've watched all your videos and learned a lot, thanks to you I'm not exaggerating. I am very grateful. There are not many people like you who share his talents with the whole world for free. Your knowledge amazes everyone with your talents and with enthusiasm. You are an endless source of inspiration. Good luck to everyone learning to code. As always impatiently awaiting this instructive video. Good health and happiness dear Randy
Wow, all of my videos. Thank you so very much, I really appreciate that and I am sure you will love this training as well :)
We hardly encounter people like you! You're amazing, May God Almighty reward you!
Thank you so very much. I really do appreciate that.
Finally this is what I've been waiting for ...There are no words that will do you justice ..
Thank you Randy...
For sure, you are very welcome and I am sure you will love this training. Please like and share the video. Much appreciated.
This looks amazing. Almost everyone needs some kind of protection from time to time. Can’t wait. Thank you for sharing.
For sure, you are very welcome and I am sure you will love this training. Thanks for your continued support
Randy, I can't tell you how much I appreciate all the valuable info you provide for free! Thank you so much.
Thanks so much. Very kind of you and I am happy to help and share
Sir so amazing & lovely application
Thank you so very much. I am really glad you enjoyed it
The very best I have seen. Thank you Randy.
Thank you so very much, I really appreciate that
Thank you for your Likes, Shares & Comments. It really helps.
This looks amazing, can't wait to see how it works
Thank you so very much, I really appreciate that and I am sure you will enjoy the training
Thank you Randy. Some new tricks learned.
For sure, you are very welcome Malcolm and happy to help and share
Hola Randy, haces mis martes alegres esperando tu video tutorial. ¡Gracias!....Eres una gran inspiración. Saludos desde Nicaragua.
Muchas gracias, realmente lo aprecio y estoy muy feliz de crear esto para ti cada semana.
Hi Randy. Thank you for this awesome training.
For sure, you are very welcome and happy to help and share Raymond
Hey Randy, great video! I was wondering for a long time how you protect your applications. Thanks for posting!
For sure, you are very welcome Kai. I am so glad you enjoyed it
Im not missing this for any reason, Thanks Randy cant wait for this incredible tutorial.
Great to hear that. I know you will love it. Much appreciated.
Was waiting for this for a long time
Excellent. I am sure you will love it. Thank you
You'll go down as the GOAT 😉 You are doing a mega Job Mr... Thanks for the useful information you have provided
Thank you so very much, I really appreciate that and so glad you enjoy the content
This is amazing. Thank you so much Randy for this share.
Glad you enjoyed it and thanks so much as always Syed!
Hi Randy ... WOW these are some super awesome features and thanks for the reminder as I have not used some of these in a long time. Very useful and inspirational. Thank you Randy
Thank you so very much Neren. I appreciate that and I am glad you were able to get a lot of value from it. Thank you for your Likes, Shares & Comments. It really helps.
I can't wait, That's going to be a huge training. Thanks Mr. RANDY
For sure, you are very welcome Sebastien. I am happy to help and share
Thank you
For sure, you are very welcome and happy to help
I am really excited for the forthcoming knowledge development. Thank you for all that you do to impact us.
For sure, you are very welcome and I am really happy I can help and share.
Great training as usual. More ways to protect projects, just what I need. Thank you so much
Thank you so very much, I really appreciate that Ian. I am glad I can help
Masters work once again... Thanks a lotttt for spreading your knowledge
You are very welcome. I am happy to bring this training to you. Much appreciated.
Very useful video. Many good tips about protection grouped so it's easy to pick those that you want to use in your own spreadsheet. Excellent instructor.
That is great to hear. I am so happy to help and share
This is amazing 👍
You always give me the poise to learn Excel more and more👌
That is great to hear, and puts a smile on my face. Thanks for sharing
There is a nice trick you shared in this training. 🎉🎉🎉
Thank you Sammy. This is one of my favorites
Thank you for this!
For sure, you are very welcome. I am happy to help and share
i am learning a lot here though coding is like Chinese to me... thanks a lot Randy for all the efforts you are putting.
For sure, you are very welcome and happy to help. This one was a big complex for beginners but last Tuesday i had a great one for beginners here: th-cam.com/video/hv3I-4L-hWk/w-d-xo.html
I hope this helps and thanks so much.
@@ExcelForFreelancers i cant wait to check it 😊
This looks amazing
Thanks very much. I am sure you will really enjoy this training and learn a lot.
Thank you for your Likes, Shares & Comments. It really helps.
Great video! Thanks
Glad you enjoyed it and thanks so much
That’s GREAT! Could you explain XLS PdLock with more details, please?
Hi and thanks so much. You can learn all of the details on XLS Padlock here: bit.ly/SecureExcel
I hope this helps and thanks so much.
Randy, thanks for this, I know it is going to be a good one, knowing how you do your training, looking forward to this one as it is very needed for excel programmers. Can wait. Going to go sleep early every night so next week can come quick. Hope you'll cover how to not allow people to copy your work to different workbooks, this is what I'm struggling with. They copy your work to different workbook and have access to all your hard work. Thanks much appreciated. If you can show how to prevent copying you worksheets but allow people to paste information in the tool. I know this is a long message ,but I'm just super excited, please can you cover hiw to make your vba code unviewable the proper way and the request above regarding the copying .
HI and thanks so much. Yes certainly I will cover that, as I show you how to tie Excel to a specific machine, and disable the save as, and hiding the VBA code. Everything will be covered in this single training.
I hope this helps and thanks so much.
@@ExcelForFreelancers thanks so so so so much, looking forward, can't wait
We need more like this sir
Thanks so very much. I will do my best to create more trainings like this. Thanks again
One day I will pay you back you make difference in my life thanks.
Thank you so very much, I really appreciate that and thank you for your Likes, Shares & Comments. It really helps.
Thanks a lot!!!!!!!!!!!!!!!!!!
For sure, you are very welcome and happy to help
Brilliant, Brilliant, Brilliant, more than I expected, even cover what I was asking for. One question Randy, the machine ID, if I have a sheet outside of the application that I have a list of machine and I want the application to check if the machine is in the list and if so allow access else close application. Your response will be much appreciated
Hi and thanks you can open the sheet within VBA and then use the FInd command to check if the file # is within the list or not.
I hope this helps and thanks so much.
Hey Randy,
First off, I just want to say I'm a huge fan of your videos. The amount of work and dedication you put into explaining complex topics is truly commendable.
However, I've been doing some digging, and it seems like everything you're explaining about protecting spreadsheets can be cracked in less than a minute. I'm pretty sure you're aware that the standard methods like password protect, structure protect, and VBA project password protect, unfortunately, can be hacked and cracked under five minutes, for free.
Do you happen to know of any unconventional or more robust ways to protect spreadsheets? Such as protecting the codes though add-ins?
I'd love to hear your insights on this matter. Keep up the great work, looking forward to your next video
Hi and thanks for your comment I am so glad you enjoy the training. If you want to go beyond Excel's own security you can try a product like XLSPadlock bit.ly/SecureExcel
I hope this helps and thanks so much.
Yes!
Thanks so much. I know you have been waiting for this one. Thank you for your Likes, Shares & Comments. It really helps.
all vides very useful
Thank you so very much, I really appreciate that Osama. I am sure you will love this one
Hii,,, I'm Nandan Mishra from Ara bihar India,,,and I like your all video,,,, i use your best video
Thank you so very much, I really appreciate that Nandan and great to have you here
Hi Sir. Good Day! It is very informative to watch your videos. I am learning a lot.
I would like to ask if it is possible to lock excel workbook in a single storage (like USB) using serial number and if copied to other storage if excel will automatically close once opened?
HI and thanks. Yes it is possible using xlspadlock here bit.ly/SecureExcel
I hope this helps and thanks so much.
Hey Randy, thx for the great Video, I have one Question about the Loing Process for the Users. Why are you not using the current UserName from the Microsoft Account? I was trying to do that. Because then you do not have to generate a Password for the Users. What is your opinion on that
HI and thanks very much. Many users and admin prefer to assign their own users and passwords, separately from their Microsoft usernames and passwords. Also I like to have my templates available for even very old versions of Excel in which the Microsoft username does not exist. This way, these templates and applications are fully backward compatible. Admins also have the ability to revoke access to end users. I hope this helps and thanks so much.
Hi Randy, hope you are well, thanks again for the training, it is brilliant, I'm hoping you can help me, I like the disablement of the copy cut paste, however, I need to disable the copy cut, but allow the user to paste data from a report that they pull for the business system, I tried playing around with the code that you provided in the training. Can't seem to get it to work, I also been looking on the internet but can't find anything that can help me, I can copy the work from another source but it doesn't allow me to paste. Hope you can help, thanks again for all your training, I really appreciate the time , effort and knowledge you out in to do the training with us, yiur channel is the best out there.
HI and thanks so much. You can activate the Paste by setting a few of the values to True, within the macros. It would be difficult to say exactly where, since i can't put all of the code inside a TH-cam response, however if you need help with this I would be happy to refer you to a qualified developer (Randy@ExcelForFreelancers.com )
I hope this helps and thanks so much.
That's good is there anyway you can convert your excel worksheet to exe executable file using only VBA without using a third party softwares
HI Keith it may be possible however i have just used 3rd party software to do it, so i am really not sure without.
I hope this helps and thanks so much.
Hey Randy, how can I use this to lock cells but allow the format control drop-down list to work properly to filter in my dashboard?
HI and thanks. yes this will work just fine, so no problem. Just make sure to unprotect any cells in which you want the end-user to modify.
I hope this helps and thanks so much.
Hello Randy, just have a quick question. Have you created any videos on User interface on VBA? I meant to say like an application where the data is getting stored in the excel file but the user see all that info in the form on user interface, instead of excel?
Hi and thanks very much for your feedback. The term 'User Interface' generally means what the user sees, So almost every one of my videos has a user interface in which the user sees and works with, while the database is generally hidden. Excel can be manipulated and coded so this is all that is needed and not any other outside application. All that is required is the desktop version of Microsoft Excel. I hope this helps and thanks so much.
Hi Sir ,
Thank you very much for this video.
Please, would mind sending the code vba to get Mac Machine Id.
It's not clear to note in the video.
Thank you very much.
Hi Claude, Thanks so much. You can download this file using the links in the description under the word DOWNLOAD. This should work for hte Mac's as well. I hope this helps and thanks.
@@ExcelForFreelancers Hi Sir,
Thank you very much.
Any thoughts on digital signatures? Are the 3rd party cert providers worth it? Enabling macros on the clients computer is always a stumbling block.
Hi and thanks. Digital signatures can be helpful, however they may not solve all issues. I can understand the challenges, and now with the added security, however, i just created a page to help people activate macros, and just send them there. It has not been too much of a stumbling block. Here is the page
www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/
I hope this helps and thanks so much.
This is excelent but I have one question. Is it possible to prevent copying Power Query (right click on query and then copy)?
Hi and thanks. It may be however I have not tried it with Power Query.
Thank you for your Likes, Shares & Comments. It really helps.
As always it's an awesome video. Quick question, if I subscribe to your patreon, would I be able to download the updated Dynamic userform example file as you mentioned in a past video including the delete and update buttons ? Thanks again Randy
Hi and thanks so much. Yes you would, I do have that updated training and download available for our Silver and Gold Patrons.
I hope this helps and thanks so much.
@@ExcelForFreelancers it sure does, thanks a lot !
great job, but I have one question. how can we protect the final executable code to be reused on just one machine...in other to avoid people to give the same executable to their friend .
executable should be used by the client only...he should not be able to share it. how can we do that ?
thank you🙏
Hi and thanks. You can write your unique code to that computers registry on registration. Then each day check to make sure the computer in which the application is on matches the registry ID. This will ensure that only one computer is used per registration. I hope this helps and thanks so much.
In the near future I will be creating an entire course on how to secure & license your Excel-based application & Addin to help answer all of these questions.
Thank you for your Likes, Shares & Comments. It really helps.
My users can open the spreadsheets on SharePoint both in Excel Online and Desktop app.
I don't see how I can prevent the spreadsheets to be opened in Excel Online and then the macros don't work.
Is there a way to enforce use of Desktop app when files are stored on SharePoint? Is the solution to use OfficeScript instead? (of which I know much less than VBA, so I would like to avoid OfficeScript)
Hi Joe, thanks for your message. I do not have a lot of experience with Sharepoint, however, if you simply want to share the files, why not use a Shared folder such as the Free Dropbox. I have been using it for years without issue.
Concerning the answer, I put it through ChatGPT since I don't have Sharepoint set up here, and here is what ChatGPT came up with:
"As of my last update, directly enforcing the opening of Excel files with macros in the desktop application when they are stored on SharePoint or OneDrive is not straightforward due to the limitations in the way Microsoft handles file access via SharePoint and OneDrive web interfaces. Excel Online does not support the execution of macros, which can be a significant limitation if your workflows depend heavily on VBA scripts.
However, there are a few strategies and best practices you can consider to guide your users towards using the Excel desktop application:
Educate Users: Sometimes the simplest and most effective strategy is to ensure that your users are aware of the limitations of Excel Online, especially regarding macros. Inform them that they need to open certain files in the Excel desktop app to ensure full functionality. This can be done through training sessions, emails, or popup messages within the organization.
Use Workbook Open Event:
You can include VBA code that checks if the workbook is opened in Excel Online. While you can't force it to close or switch directly to the desktop application, you can display a message instructing the user to open the file in the desktop version of Excel. Here's an example of how you might set up such a VBA script:
VBA CODE:
Private Sub Workbook_Open()
If Application.Online = True Then
MsgBox "This workbook contains macros and must be opened in the Excel desktop application for full functionality.", vbCritical
' Optionally, you could close the workbook
' ThisWorkbook.Close False
End If
End Sub
File Naming Conventions: Use file naming conventions to indicate that a file contains macros and should be opened with the desktop application. For example, prefixing file names with "MACRO-ENABLED-" could alert users to the need for the desktop app.
SharePoint and OneDrive Configuration: If possible, adjust SharePoint or OneDrive settings to favor opening files in the desktop app. However, this is typically limited to global settings that affect all documents, which may not be desirable.
Distribute Desktop Shortcuts: For key documents, provide users with desktop shortcuts that open the Excel files directly in the desktop application. This method bypasses the web interface, reducing the chance that users will inadvertently open the file in Excel Online.
Advanced Techniques: For organizations with access to advanced IT resources, you could explore using group policies or developing a custom solution that integrates with SharePoint to enforce opening certain files with desktop apps. These solutions would likely involve significant customization and IT involvement.
Check Access Type: If feasible, use the Excel capability to check how the workbook is being accessed and provide feedback or restrictions:
VBA CODE:
If Not Application.CommandBars("Workbook tabs").Enabled Then
MsgBox "This workbook is viewed in a browser (Excel Online) and will not function correctly. Please open it in Microsoft Excel on your desktop.", vbExclamation
ThisWorkbook.Close savechanges:=False
End If
While none of these methods are foolproof or can enforce the opening strictly in the desktop app without user compliance, they can help manage and guide user behavior more effectively."
Hi Randy, hope you well. I built an application where I use the protection code, downloaded the UI editor, works fine on my laptop, however, I saved the workbook on a share drive and it still works for, but when my colleagues open the workbook it's says the that macro is not working so they are able to use the copy and paste using the toolbar ribbon. Hiw do I get it to apply on their laptops. Thank you so much.
Hi and thanks. As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can have your friends 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/ Have them follow step # 2
I hope this helps and thanks so much.
Thanks Randy, the check
Hi, I had to run the script on their laptops, and it's working now, thanks
OK very good, I am glad you got it working :)
Dear Sir, please make a full course on creating Excel Application from which we can sell our services on freelance market. Please sir kindly make it happen. Thanks
HI and thanks very much. I do have that already in my Mentorship course here
www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
I hope this helps and thanks so much.
How about the new security of microsoft that block macro from running does xls padlock will unblock it automatically??
Hi and thanks for that. There is a simple fix for that and I have outlined it here on this page
www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/
I hope this helps and thanks so much.
@@ExcelForFreelancers i already know this sir. But this is very hastle when selling an excel application. Because not every buyer knows how to do it even if you give them an instruction or video instruction. Very hastle.
I 100% agree with you, but that decision was made by Microsoft :(
Hi,can you show us how to prevent user rename file extention to older version then lost all axtive x
Hi and thanks for your comment. I suggest using a shared & backed up folder such as Dropbox, OneDrive or Google Drive. This way you have a saved version online so you can revert back to any version you want in case of mishap.
I hope this helps and thanks so much.
Another problem I use active x a lot in my file when computer update I lost all my listbox active x and remain active x became picture
Do use know how to prevent it???.
Hi and thanks very much. I had not heard of that issue, however if you are using a Mac I know they do not run Activex. With a WIndows PC, an update should never affect most Activex controls.
I hope this helps and thanks so much.
Hi Randy, facing some problems with the mac code it kicks up a run-time error "429" active x component can't create object. is there any new code?
Hi and thanks very much. Activex controls do not work on Macs. Mac's have a very limited feature set when it comes to working with Excel VBA. You may want to consider using Parallels which will mimic the PC environment on your Mac.
I hope this helps and thanks so much.
Yes I got it, thanks and noted :)@@ExcelForFreelancers
When you password protected the range 'InvoiceList', does it work dynamically in case you increase the size of the range?
HI and thanks for your message. Yes, since the range is dynamic, it will grow as the data grows, and remain password protected.
I hope this helps and thanks so much.
Hi there, question! when you send a new app to a paid customer, then its waiting to be registered and the app pulls the machine ID into the app and you send them their Lic.Key. well what will happen if they take the original app(which you emailed) and open it on a new machine and put in the same Lic.Key? because the original app machine ID is blank...
Hi and thanks for your question. When they originally register it their machine ID is saved in a secure location. Each time the app is opened, used or at regular intervals, the machine ID is checked that the current machine ID is the same as the one saved in the secure location. If the ID's are different then we know that this is not the original machine and a user can be restricted.
I hope this helps and thanks so much.
Thanks for your reply, but how are we to know or check their ID if they have the App? as the registration does not send us that information(Machine ID)@@ExcelForFreelancers
Hi Billy, thanks for your question. I share that with you in this training: th-cam.com/video/l-tgyQvdC5g/w-d-xo.html
I hope this helps and thanks so much.
Hi thanks again for your prompt reply, I think I figured it out :0@@ExcelForFreelancers
OK very good, Thanks so much
Unfortunately, there is no XML code in the link file in CutCopyPaste_Macros module! I will have to write the XML code manually.
HI and thanks I am not sure what xml code you are speaking of. Can you provide more details? Which training are you referring too?
@@ExcelForFreelancers Hi, Randy ! The XML code template is missing in the link file in "CutCopyPaste_Macros" module. More details here 38:20.
About me, it's ok, I typed that XML code snippet manually, it's small. It's okay!
Ah now I understand. Actually, you don't need to retype it. Yes you are right the xml code is not inside the module, but it is inside the workbook. So first you would download the Free Office RibbonX Editor, then you would open the workbook with the editor, and inside there, you will find all the xml code (here is a screenshot www.dropbox.com/scl/fi/9dv11s1xx9r2v5hue0gwb/XML_Code.png?rlkey=iemazyoxfy4pwenwokez6wnou&dl=0
I hope this helps and thanks so much.