Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

Insert Picture

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mcp6453 - 14 Jun 2007 16:30 GMT
In Excel 2003, I have a form to which I Insert a Picture from a File.
The picture is a TIF (it's a scanned signature). When the picture is
inserted, its background is white/opaque. If I select a transparent
color (white) from the toolbar, the background disappears, and the grid
and form lines are visible underneath the signature.

The question is, how can I modify the TIF drawing such that the
background is transparent when inserted such that I do not have to go
through the extra steps each time? I hoped that I could select the
picture, which Excel modifies on insertion, and do a File | Save As, but
that function is not available. What is the native format of the picture
in Excel after it is inserted?

Hopefully this question makes sense!
Gord Dibben - 14 Jun 2007 17:53 GMT
Excel won't save the *.TIF file

You must edit that in your favorite graphics application to the transparent
background.

OR...........record a macro while you Insert the picture then modify.

Assign that macro to a button or shortcut key combo.

Gord Dibben  MS Excel MVP

>In Excel 2003, I have a form to which I Insert a Picture from a File.
>The picture is a TIF (it's a scanned signature). When the picture is
[quoted text clipped - 10 lines]
>
>Hopefully this question makes sense!
mcp6453 - 14 Jun 2007 20:46 GMT
> Excel won't save the *.TIF file
>
> You must edit that in your favorite graphics application to the transparent
> background.

The question is a little more complicated than that. Even though the
picture is imported in TIF format, it appears that Excel internally
converts it to some other format. If I knew what format it was
expecting, I could probably do the conversion externally. I seem to
recall that the TIF format does not allow transparency, but that
recollection could be wrong. PNG and GIF do have transparency, so maybe
Excel is converting to one of those.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.