• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create Custom Shapes through VBA

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.
 

Attachments

  • OOCL Logistics Shape.xlsm
    24.5 KB · Views: 33
Back
Top