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 :)

Thank you so very much. I really do appreciate that.

For sure, you are very welcome and I am sure you will love this training. Thanks for your continued support

Thanks so much. Very kind of you and I am happy to help and share

For sure, you are very welcome and I am sure you will love this training. Please like and share the video. Much appreciated.

That is great to hear. I am so happy to help and share

Thank you so very much. I am really glad you enjoyed it

Thank you so very much, I really appreciate that and so glad you enjoy the content

Great to hear that. I know you will love it. Much appreciated.

Thank you so very much, I really appreciate that and I am sure you will enjoy the training

Thank you so very much, I really appreciate that Thank you for your Likes, Shares & Comments. It really helps.

Muchas gracias, realmente lo aprecio y estoy muy feliz de crear esto para ti cada semana.

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.

For sure, you are very welcome Sebastien. I am happy to help and share

Excellent. I am sure you will love it. Thank you

For sure, you are very welcome and happy to help

For sure, you are very welcome Malcolm and happy to help and share

For sure, you are very welcome and happy to help and share Raymond

Thank you so very much, I really appreciate that Ian. I am glad I can help

For sure, you are very welcome and I am really happy I can help and share.

For sure, you are very welcome Kai. I am so glad you enjoyed it

Glad you enjoyed it and thanks so much as always Syed!

Thank you so very much, I really appreciate that Nandan and great to have you here

For sure, you are very welcome and happy to help

That is great to hear, and puts a smile on my face. Thanks for sharing

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

You are very welcome. I am happy to bring this training to you. Much appreciated.

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.

Thank you Sammy. This is one of my favorites

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.

For sure, you are very welcome. I am happy to help and share

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: kzfaq.info/get/bejne/ntxjfJBlsZPMh58.html I hope this helps and thanks so much.

@@ExcelForFreelancers i cant wait to check it 😊

Glad you enjoyed it and thanks so much

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.

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.

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 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.

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.

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.

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.

Thank you so very much, I really appreciate that Osama. I am sure you will love this one

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 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 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.

Thanks so much. I know you have been waiting for this one. Thank you for your Likes, Shares & Comments. It really helps.

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 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 KZfaq 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 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.

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 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 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.

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

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.

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 :)

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 !

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: kzfaq.info/get/bejne/opOkmtyC28qnZZs.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

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.