View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gejmond
 
Posts: n/a
Default Positioning all pictures

Hi

Can anyone please advise on how to change the positioning properties
for 'all' the pictures on my spreadsheet?

In order to sort properly without the results distorting the pictures,
I need to set their positioning to "Move but don't size with cells".
Doing this individually would mean selecting format picture then going
on to the properties tab. However I can't seem to be able to do this
for multiple pictures, and I have lots.

I suspect the answer is in VBA (whatever that is!) I have used VBA
before to set up a macro for something but just followed exactly the
very good instructions from another poster, so I'm completely novice at
it really.

Any help would be greatly appreciated!

gejmond