Avatar of henry_0530
henry_0530
 asked on

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.
Microsoft ExcelVBA

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
[ fanpages ]

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy