How to make a picture transparent – Macro

In an earlier article, I had shown a method of making a picture transparent using the Transparency animation. This method shows the transparency only while PRESENTING – not while EDITING. Here is a macro which will help you create a transparent copy of any picture which is transparent during editing as well.

image

Continue reading

Pivot Filter Explode Macro

Refer to the previous post. We saw how Filter fields can be exploded into individual sheets and files. In this article, I am releasing a macro – which does all the hard work for you. Of course, you must use it at your own risk. The source code is also included for you to view, learn from and modify. Created by Raj Chaudhuri and myself.

image

Photo credit: Johnson Cameraface / Foter / CC BY-NC-SA

Continue reading

Paste Special Pivot – New way to use Pivot table data

image I created this utility (macro) along with Raj Chaudhuri. It helps you in copying cells from Pivot Table and pasting them as GetPivotData functions.You must read this article about GetPivotData in order to understand the background information.Estimated reading time 8 min

Continue reading