Thread: macro
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mac Mac is offline
external usenet poster
 
Posts: 213
Default macro

Jim
THANK YOU IT WORKS!!!!!!!
--
thank you mac


"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