MS EXCEL macros/VBA migration to new tool.

[Nikhil2803]

Hi Team,

I have a created an excel template that is having lots of validations using macros/VBA code. All the validations are working as expected in the client network. I am sharing the excel sheet outside of the client network as an attachment over email.

When the user is downloading the file in his local system and trying to open the file, he is getting the below error.



Now, We have the solutions for that, but that we need to do manually, but client does not want to update anything manually.

Could anyone suggest which is the best way to migrate these macros validations excel setups to some tool using other recent technologies(most preferably MS technologies). I want to replicate the same steps in some other web/desktop tool that I have given in the excel. As a heads up, in sheet2 of excel, user has to put data in various columns, and the data needs to be validated according to the macros code that has been setup for that.

Any help on this is highly appreciated.

 

[Joe4]

Note that if you sign your VBA code with a digital signature, your client would only ever have to accept that signature once. Then everything you send them after that will automatically be trusted (as long as you sign it with the same signature).

See here: Digital signatures and code signing in workbooks in Excel - Microsoft 365 Apps

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Redirecting

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.