Macros/Tracking/WorkBook Sharing Help Please

B

Bill King

I have a convoluted problem - Hope I can explain it
clearly.

I have a Shared Workbook on our network. In order to see
changes that another user has made a user must select
TOOLS==>TRACK CHANGES==>ACCEPT OR REJECT then choose
Accept All. I want to create a command button on the
worksheet with script that will perform these steps.

In order to perform the steps, to build the macro
instructions, the workbook must be in "shared" mode. The
problem is that once the workbook is in "shared" mode the
macro editor is not available.

If anyone understands what I am trying to describe, I
would appreciate some help.
Thank you
Bill King
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unclear change tracking process 0
Sharing workbook removes cell protection 1
Macro can not unprotect a sheet in a shared workbook 4
Can Sharing Workbook Corrupt Sheet Password? 0
Can Sharing Workbook Corrupt Sheet Password? 0
How to run auto-open macro in Excel 2007? 3
Macros failing when workbook is in shared mode 1
Tracking Changes in a non-shared workbook 1

Top