Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple spreadsheets | Setting up and Configuration of Excel | |||
delete multiple autoshapes or objects in excel | Excel Discussion (Misc queries) | |||
conditional formatting autoshapes | Excel Worksheet Functions | |||
Conditional Formatting with two Spreadsheets | Excel Worksheet Functions | |||
How to update multiple links in multiple spreadsheets followin mo. | Excel Worksheet Functions |