Saving a visual basic (myfunc)

i generated a new module in visual basic... (i'm new at this by the way)

my question is: what kind of setting do i have to establish to make sure that 'myfunc' will save in the workbook after closing?

micro settings? trust access to the VBA project object model? file block settings?

THANK YOU

Save it as an xlsm file.

When you save as an xlsx, it strips any VBA project. And xlxs extension is a promise that the file does not contain macros.

You would save the file as a .xls or .xlsm file. A .xlsx file will remove any macros/modules upon saving it as that file type.
Unless you're using add-ins, you would set macro settings to at least prompt you to run them, or to be allowed without prompting. If you personally trust where the macros are coming from, you can check Trust access to the VBA project object model, otherwise I would leave that unchecked.

Note that if you are getting macros or VBA code from untrusted sources (like, say, random places on the internet), you would probably not want to trust all of it. VBA can be used to affect files and folders on your computer that are not limited to Excel or even microsoft office files. VBA can be used to change both Windows and registry settings. This is not to scare you away, just to inform you of what blindly trusting all code could cause.

You should never, ever configure Excel to enable all macros.

Set to Disable with notification.

Use a Trusted Folder

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save