Dear Experts,
I have made and macro enabled excel file.

In the macro enabled worksheet, there are many formulas and macro in the worksheet and trying to use that worksheet as a template and i like to use that file as shared workbook, and the output of the file will be print as PDF and mail through outlook.

My query is that at a time more than 1 user will use the file and all macro should work properly.

If Every user will use the file and for all user may fill different data in the template and they can generate their own report.

Please advise and guide.

Thanks in advance.