xlam file This is a topic that many people are looking for. newyorkcityvoices.org is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, newyorkcityvoices.org would like to introduce to you Create password Protected Macro Addin – XLAM file in VBA Excel and distribute and share it to others. Following along are instructions in the video below:
“Everyone here we are going to create a small vba code to understand what is is meant by that is excel am fine and how to create this excel. Am and also how to create it as a password protected so that we can share it to others ok. So i m going to use a very simple demo to understand this concept. So the coding may be you know may not be so much important.
But the concept of how to create an excel aim and how to create it password product and then share. It so that is a cool idea of this biggie ok ok. So what i m going to do is i m going to open the microsoft excel. Okay.
So the microsoft excel is here and i can use alt f11 otherwise. I can you go to develop rows tab and you can i can use visual basic it s vs lemon. Okay. So what i m going to do is for this vba code.
Let s say i have a two more column marks column mark 1 works. Too yes so let s say. I have some wound data whether it s a demo ok so let s say this is a column. I have and i want to have the additional of addition of two numbers in the sheet to column here.
I want to display the addition. So i want to write a ho. Okay. So let us go to the visual.
Basic editor. Okay. What i m going to do is i am going to use this section. Which will basic the business.
My application so i m going to insert a model. The model is going to have the the macros okay so also i am going to use a to perform and in a user form. I am going to a simple demo application okay so i m just giving the caption ass close me. And i m going to write a code call and load me so hope you aware of the visual basic coding okay so in the model language call this user form i m going to show this visual form so in the model model is the one where you know the macros is going to get called okay so this vba is that is going to be the protector xl am fine okay so i m just going to do one by a step by step okay.
This calculator. Some a procedure. A macro procedure. Let s let s give the name as a protector.
This is the function the procedure name and i m going to call the user form one here. Da schon. Okay..
So now what i will do is i will go to the excel page. And i will run the macros. So now i caught that so my i click close me. It will invoke plain and old made function.
Let s go so it works fine. So now let us write a simple code in the in the user form wait a another button. Addition okay and i m going to copy this. Oh see the purpose of this video is not to actually tell you what is meant by which will basic coding purposes to create how to create a lan fine.
So to explain this simple coding. I have created a declared worksheet and i have said that okay. This worksheet is going to use the sheet. 1.
And then this sheet 1 add. The second row. First column and second row second column and put it in an integer and use another worksheet. Which is called g 2.
In the same workbook and in the first row first column. Give a label called the out loop output and in the first one second column. Give that output that is analog ok. So now let s close this and then outright.
It s good. It s oh i m expecting that no she it shouldn t have that output of this edition. Okay so let s try to run this edition. Done it so i m just closing it so now i see that 49 79.
So so. The coding code works fine okay so with this confident. I m going to you know create a excel am fine and also i m going to make it as a password correct er okay. So the macro name is protected code just copy that okay now what i m going to do is i m going to save this project as excel.
Am five and the four that i am going to give a project name or as a record code. Okay. I m just using the same neck host for simplicity. And i m going to use a password.
I m going to lock this code. So that no one can use this code. Okay let s let us give..
The simple password whatever you like okay. So now i have given the password. So what i m going to do is i m going to save it just select. This and click save now it will ask you whether you want to save it as accept movie.
I don t want to save it so. What i will do is i m going to save it as excel am fine okay. So let s save as excel. Am file.
Okay. This is excel add in okay. I m going to save it as also protector so protected code dot x. L.
Am. Fine. So let us save. It okay.
Now the code is protected now okay so now what i m going to do is i m going to say close and then i m going to say i m going to close excel as well i don t want to save it i m going to say no okay so now i have an file called protected for not actually in fine. So. Which is the password protected. Okay.
Now i am supposed to create another excellent file. So that that file is going to call this protected code talk excel. Am fine. So that if i forward if i share that excel.
Am file and also the new one that i created i can ensure that this food is completely productor and known can view this video code okay so let us go and open an another excel file. Okay i have opened it so i am going to the which will be picked. Okay. So here is the new new one so what i m going to do is i am going to insert a new model here and i m going to call that excel a in part.
Which has the knife. Oh. This is a possible problem. So i m just going to call.
So the main excel am. And here we have the code. Because a textbook you aware of that vd for applications of run okay..
So what what what we are doing is unhauling the excel in fine. Okay here okay that excellent fine and also i m going to call the function. Which is their model one and i think the macro function is also perfect for okay so to do that let us try to do the give the reference of this particular aquarium file. For this new project.
So go to the tools. The friends and browse and i think we have to go to the videos. Why we have kept so i think i have pictured here and let me select either you can select all files of excel am and i have seen and using this product or code just open that and now you will see that there is i have friends added. And say ok.
And now you will see that it is a reference to x l. Am. Fine so now if i call this model which has the main xlim function it will actually automatically call this excel file. Which is actually protector also protector file.
And it calls the model and the macros inside it but a crypt code. So that i am going to secure this xlm file. Even i am i can satisfy without actually sharing the code. So what i m going to do is i am not going to put a protect this project as well the password.
I am going to just leave it and i am just going to save this and i m going to distribute this fight. I m going to save this as an excel. I am fine as and plus that so let me do that so i m just going to save before saving you know let us try to see how it is working. So this close it and use the same function let s say 10.
20 and i m going to call the macros main excel am and going to run. It see it is able to identify that original excel a and 5. It is able to still pull that data so i m going to add it close it now i ll see that there is an output. So it works fine okay so let me go to the visual.
Basic editor. And i am going to save this project. In the same same location as an another add in i am going to say and give a given give a different name let s say main code not excel am. So let me save that okay and if you see that you know if i just expand this the the original one corrected for it will last the last four password and this one.
I m going to distribute it so once i close it and reopen it it will say main underscore four dot x l. Am. Fine. So now what i can do is i can just simply close and also i can close it i don t need to save this excel file.
Anymore. It will ask for it will ask whether we know you want to close it so just keep it close it last. Whether you want to save this excel..
No i do not want to save. It okay so now the benefit is you know i have two excel files. One is the corrected code. Not x.
Lan and also there is a two second and the second sale. All the main robotics at am. So this is the password protector and this is not so i can i can cover these two files to anyone to use it okay so to how to use it in add in let s go to my microsoft excel and add this excel am macros as it as in a toolbar or in a quick toolbar no you can add it anywhere so just open the microsoft excel now. So.
What you have to do is just right click and go to the quick access toolbar go to the add ins and select go browse. Fortunately. It is already there in the same location. So if i select this for a third board.
I may not be able to view the atom okay so i have to select the the main code or excel am. Which is actually internally calling this product code night force okay select. This main code and say okay. That says you want to there s already if there is a message say yes to that okay now i can say that there is a main code selected and then just going to say okay.
And i m going to i want to add this in the crick toolbar. Okay so go to the same location again go to the quick access toolbar. Select the macros and you will see that main excel am file is already showing now. This is the final okay so now just add this here so that it will visible here.
Okay. If you want to change the the name and the icon just click on modify and you can use any any options addition you can just cube. Say addition. The state explained name okay.
Just say okay and hit open. So now you see that there is an icon. Okay so here now if i try to do the demo okay total pie okay now if i click on this edit this icon. Now i haven t seen that i m able to pull the excel am file let close me try it once again click addition it close me.
And it s betting. The output is clarify here okay so now hope you understand what is meant by the excel am file. And how to create it as a password protected and also how to share that excelling file to anyone without and over a toad actually it s basically showing what is the code you have rhythm. ” .
Thank you for watching all the articles on the topic Create password Protected Macro Addin – XLAM file in VBA Excel and distribute and share it to others. All shares of newyorkcityvoices.org are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.