Thread: macro
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default macro

Perhaps you only copied the bottom 6 lines of Jim's post, because there
is a blank line in the macro - there are three other lines above this,
starting with:

Sub RemoveShapes

Hope this helps.

Pete

Jim Thomlinson wrote:
Not too sure what the problem might be. It worksin mine... In the VBE select
Debug - Compile... Which line shows the error? Double check tools -
references to ensure that none of the references are tagged Missing:
--
HTH...

Jim Thomlinson


"mac" wrote:

Jim

Thank you for answering so quickly,. As you can tell I am new to macros.
When I copied this into the visual Basic. it comes up with an error (sub or
function not defined), Could you help with this. Again Thank you.

"Jim Thomlinson" wrote:

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