|
|
New! Excel User Group Now Open @
www.excelusergroup.org,
|
 |
| Menu command |
Type |
What happens next? |
|
Picture |
► |
Has a submenu
detailing
all the types of image or picture that can be
inserted into Excel. Most of the options, shown
right are self-explanatory, but for the sake of
completeness we list them here.
-
Clip Art...
- Fires the clip-art 'task
pane'. This will list clip art on your
machine (if installed with Excel) and if you
are online, clipart and images, etc from
Microsoft's clip art gallery.
-
From File...
- Shows the standard file dialog allowing
you to select any images, locally, on a
network or the internet.
-
From Scanner or
Camera... - Connects you via the
Scanner/Camera wizard to download pictures
from connected devices.
-
Autoshapes
- Shows the Autoshapes toolbar to make a
selection from a huge array of call outs,
lines, arrows, shapes, etc
-
WordArt -
Launches the WordArt Gallery to create
sizeable, customisable text shapes.
-
Organisation Chart
- Places a default organisation chart on the
worksheet and launches a complimentary
toolbar allowing you to build charts similar
to Visio.
|
| VBA |
Sub AddPic()
Dim wks As Worksheet
Set wks = ActiveSheet
wks.Shapes.AddPicture "C:\Nickh.jpg", msoFalse,
msoCTrue, _
100, 100, 80, 100
End Sub |
Top
|
|
Copyright Nick Hodge 2009. All Rights Reserved. |
|
 |
|