chirayu
Well-Known Member
Hi All,
Thought I would upload this as it may be useful to you. The main reason behind this R&D was to reduce file size.
For example usually what most people do is create a “Please Wait” message on a hidden sheet & display it when their macro runs. This makes the file heavier as you are dedicating that extra sheet & any formatting/logos on that sheet for use by the Macro.
Instead of doing that you could create a custom shape that could mimic a logo & delete it after macro ends. So I’ve attached the sample file explaining how to do this.
My Macro isn’t comprehensive but covers the major areas like Shape borders, text, fill/ transparency, font size/type/style/colour, text indent etc.
Thought I would upload this as it may be useful to you. The main reason behind this R&D was to reduce file size.
For example usually what most people do is create a “Please Wait” message on a hidden sheet & display it when their macro runs. This makes the file heavier as you are dedicating that extra sheet & any formatting/logos on that sheet for use by the Macro.
Instead of doing that you could create a custom shape that could mimic a logo & delete it after macro ends. So I’ve attached the sample file explaining how to do this.
My Macro isn’t comprehensive but covers the major areas like Shape borders, text, fill/ transparency, font size/type/style/colour, text indent etc.