Formatting multiple spreadsheets using Autoshapes
 

Hello:

When I select multiple worksheets at once, and go into the Autoshapes
drop-down menu, everything in the drop down menu is greyed out. I want to
format multiple worksheets at once, with shapes - any suggestions?

Thanks,

Patricia

Formatting multiple spreadsheets using Autoshapes
 

The shapes are objects, they aren't "in" the sheet.

Fuel Cells for the Future wrote:

Hello:

When I select multiple worksheets at once, and go into the Autoshapes
drop-down menu, everything in the drop down menu is greyed out. I want to
format multiple worksheets at once, with shapes - any suggestions?

Thanks,

Patricia

Formatting multiple spreadsheets using Autoshapes
 

Sub Add_Shapes_To_All()
Dim ws As Worksheet
For Each ws In ActiveWindow.SelectedSheets
' For Each ws In ActiveWorkbook.Worksheets
ActiveSheet.Shapes.AddShape(msoShapeCross, 504.75, 65.25, 104.25, 113.25). _
Select
Range("A1").Select
Next ws
End Sub


Gord Dibben MS Excel MVP

On Thu, 11 Oct 2007 08:42:02 -0700, Fuel Cells for the Future
wrote:

Hello:

When I select multiple worksheets at once, and go into the Autoshapes
drop-down menu, everything in the drop down menu is greyed out. I want to
format multiple worksheets at once, with shapes - any suggestions?

Thanks,

Patricia