Sharing macro enabled excel sheet

**arunbjaidev** · 08-13-2013, 02:52 PM

Need help..how to create a macro enabled excel which can be shared for multiple users and the data entered by them should be captured in the same sheet.

**codeslizer** · 08-14-2013, 04:09 AM

Basically, macros are always enabled whenever you share the macro-enabled excel files. But it has limited access and cannot perform tasks such where the security is a concern like hide/unhide, protect/unprotect, delete or format cells or sheets. Also one cannot define macros when file is shared. Macros which involve setting formulae, editing values might work, in general, all calculation operations would work to an extent.

Hope, this answers your question.

**arunbjaidev** · 08-14-2013, 03:05 PM

Thanks for the reply...Just to add on to my question..i want to know how we can share the macro enabled excel (like the way we use in normal excel - Share worksheet) to multiple user and when they feed any data through user form..if two different user clicked on submit but at a single point of time, the sheet will capture only one data...i want the data entered by both the users to be in the file.

I hope my question is clear

**codeslizer** · 08-16-2013, 03:27 AM

Hey Arun,

Well, if you're asking how to share workbooks then go through this tutorial. Its pretty simple. There's an option to share within Review tab. Also I have attached a sample workbook with sharing ON - where my macro still works with multiple users updating it at the same time - as I said until you perform certain operations which make changes the structure of the excel file.

Let me know for any confusions.

P.S. To see the code section you'll have to disable the share.

**Kyle123** · 08-16-2013, 03:53 AM

If all you are doing is capturing input, have a look at google sheets and forms, for data capture, it will takes only a few minutes to create a form and sheet. The sheet updates in real time for anyone with the link, but people don't need access to the sheet to make entries; only a link to the form