I am working on a shared excel workbook and want to make use of the ActiveWorkbook.RejectAllChanges 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.
After days of bashing my head against a wall I've stumbled onto the answer.
To use this method, you must have already marked the workbook as shared under the Review menu. Once saved as a shared workbook,
With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.