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

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

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

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

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

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

Hi Jim
I know you helped me with this macro. I came across a problem and was
wondering if you could help me again. When I run this macro it also removes
text boxes, which I don't want to do. Is there anyway I can fix it so that
it does not remove the text boxes. I appreciate any help you can give me.
Thank you.

--
thank you mac


"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