gerry_ocallaghan
asked on
ActiveWorkbook.RejectAllChanges method explanation
Hi Experts,
I am working on a shared excel workbook and want to make use of the ActiveWorkbook.RejectAllCh anges method.
However any time I try and use it I get run-time error 1004, method failed error.
I can't see to find any helpful reference guides on the method so posted this question in case someone has been successful with it.
Thanks,
Gerry.
I am working on a shared excel workbook and want to make use of the ActiveWorkbook.RejectAllCh
However any time I try and use it I get run-time error 1004, method failed error.
I can't see to find any helpful reference guides on the method so posted this question in case someone has been successful with it.
Thanks,
Gerry.
>>I am working on a shared excel workbook The consensus opinion of Experts here is that using 'share workbook' should be assiduously avoided. This is a poorly implemented feature in Excel that leaves workbooks highly vulnerable to corruption. If true multi-user capability truly is needed, then the best practice is to use a database platform such as Access, SQL Server, MySQL, etc.Just about the only use for shared workbooks endorsed by the Experts here is to enable 'track changes',and even then, the workbook should still not be used by multiple users at the same time.It is only a small exagerration to say that there are only two kinds of shared workbooks: those that havebecome corrupted, and those that soon will be :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.