Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions |