Turn the white background of an image into transparent

%3CLINGO-SUB%20id%3D%22lingo-sub-2309927%22%20slang%3D%22fr-FR%22%3ETurn%20the%20white%20background%20of%20an%20image%20into%20transparent%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309927%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20from%20VBA%20to%20transform%20the%20white%20background%20of%20an%20image%20into%20transparent.%20I%20know%20the%20%22transparent%20color%22%20function%20exists%20but%20it%20doesn't%20show%20up%20with%20the%20macro%20recorder.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%2C%20I%20was%20offered%20this%20formula%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Remi131765_0-1619775630595.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F276994i9A1FF5E17BB930CF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Remi131765_0-1619775630595.png%22%20alt%3D%22Remi131765_0-1619775630595.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EBut%20when%20I%20run%20the%20macro%20I%20am%20told%20that%20the%20value%20typed%20is%20out%20of%20range%20(line%206%3A%20TransparencyColor).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECordially%3C%2FP%3E%3CP%3ERemi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2309927%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello everyone,

 

I would like from VBA to transform the white background of an image into transparent. I know the "transparent color" function exists but it does not show up with the macro recorder.

 

Can you help me ?

 

In addition, I was offered this formula:

Remi131765_0-1619775630595.png

But when I run the macro I am told that the value typed is out of range (line 6: TransparencyColor).

 

Cordially

Remi

 

0 Replies