how to share a workbook with vba project?

I created a file with a command button in sheet1 that automatically copies all of entries you encoded and paste it in sheet 2. I wanted this file to be available for other users for editing. It works in lower version of excel like 2003. but when i transferred it in a higher version like 2010, the button automatically deactivates. It only activates every time I turn off the "share workbook". I tried to create a new file using Excel 2010 version but same thing happened. Shared work book is very critical in our work as it makes our work less hassle particularly in preparing reports. Is there a way to address this..? Please help me.