| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Modify the style of a picture with VBA
On Aug 19, 7:42 pm, Dave Peterson wrote:
One more to try: Dim myShape As Shape Set myShape = ActiveSheet.Shapes("Picture 1") myShape.Shadow.Type = msoShadow5 R Tanner wrote: On Aug 19, 12:35 pm, R Tanner wrote: Hi, I have copied a range of cells and pasted them as a picture in my code. I want to modify the style of the picture to have a shadow. What is the procedure for that? Thanks The problem arises because I can't see any of the syntax with the macro recorder. I change the style, and it records zilch.... -- Dave Peterson okay Thanks. I will try your suggestions... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to stop style for col A changing to style of co D date vs $ | Setting up and Configuration of Excel | |||
| How to modify callouts in the InsertPictureAutoShape in Excel | Excel Discussion (Misc queries) | |||
| How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
| How do I convert US style dates to European style? | Excel Discussion (Misc queries) | |||
| How to modify (or add to) autoformat style? | Excel Discussion (Misc queries) | |||
Threaded Mode
