troubleshooting Question

how to share a workbook with vba project?

Avatar of henry_0530
henry_0530 asked on
Microsoft ExcelVBA
3 Comments2 Solutions221 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros