Thread: macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default macro

This should be close...

sub RemoveShapes
dim wks as worksheet
dim shp as shape

for each wks in worksheets
for each shp in wks.shapes
shp.Delete
next shp
next wks
end sub
--
HTH...

Jim Thomlinson


"mac" wrote:

I would like to create a macro that when it opened the workbook, it would
remove all pictures (which are tickmarks). Is there a way to do this or do I
have to do it manually. Any help will be greatly appreciated. Thank You.
--
thank you mac