Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 8th 09, 12:39 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 6
Default Deleteing Pictures

Hi

I am using Excel 2003 and have a question about Pictures. I have been given
a Excel file to maintain for daily meetings. The problem is that it is full
of "Picture Boxes". These Boxes are empty, but they take up space and slow
the file to a crawl. I have gone in and manualy deleted all the "Picture
Boxes" that I can find. The file is now 87.6% smaller. I am sure that there
are more "Picture Boxes". Is there a way to find them without fishing?
--
oceankayakjim

  #2   Report Post  
Old May 8th 09, 02:00 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,124
Default Deleteing Pictures

Sub eachshape()
For Each sh In Sheets("yoursheetnamehere").Shapes
MsgBox sh.Name
MsgBox sh.TopLeftCell.Address

'sh.cut ' to delete automatically

Next sh

End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"oceankayakjim" wrote in message
...
Hi

I am using Excel 2003 and have a question about Pictures. I have been
given
a Excel file to maintain for daily meetings. The problem is that it is
full
of "Picture Boxes". These Boxes are empty, but they take up space and slow
the file to a crawl. I have gone in and manualy deleted all the "Picture
Boxes" that I can find. The file is now 87.6% smaller. I am sure that
there
are more "Picture Boxes". Is there a way to find them without fishing?
--
oceankayakjim


  #3   Report Post  
Old May 8th 09, 06:00 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 6
Default Deleteing Pictures

Thanks!

I'm a bit new to Excel, (I'm a misplaced Mechical Engineer), I'll show this
to the IT department here and see if they can help me with this.

--
oceankayakjim


"Don Guillett" wrote:

Sub eachshape()
For Each sh In Sheets("yoursheetnamehere").Shapes
MsgBox sh.Name
MsgBox sh.TopLeftCell.Address

'sh.cut ' to delete automatically

Next sh

End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"oceankayakjim" wrote in message
...
Hi

I am using Excel 2003 and have a question about Pictures. I have been
given
a Excel file to maintain for daily meetings. The problem is that it is
full
of "Picture Boxes". These Boxes are empty, but they take up space and slow
the file to a crawl. I have gone in and manualy deleted all the "Picture
Boxes" that I can find. The file is now 87.6% smaller. I am sure that
there
are more "Picture Boxes". Is there a way to find them without fishing?
--
oceankayakjim



  #4   Report Post  
Old May 9th 09, 12:42 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 634
Default Deleteing Pictures

Edit / Go To / Special / Objects - Then hit the delete button

Regards
Ken.............................


"oceankayakjim" wrote in message
...
Hi

I am using Excel 2003 and have a question about Pictures. I have been
given
a Excel file to maintain for daily meetings. The problem is that it is
full
of "Picture Boxes". These Boxes are empty, but they take up space and slow
the file to a crawl. I have gone in and manualy deleted all the "Picture
Boxes" that I can find. The file is now 87.6% smaller. I am sure that
there
are more "Picture Boxes". Is there a way to find them without fishing?
--
oceankayakjim



  #5   Report Post  
Old May 9th 09, 01:18 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,204
Default Deleteing Pictures

For future reference, to insert a regular Sub or Function into a workbook:

Open the workbook and press [Alt]+[F11] which will open the Visual Basic
Editor (VBE).
In the VBE, use its menu to Insert -- Module and then copy the code
provided and paste it into the empty code module presented to you. You may
need to make changes to the code for your unique workbook/worksheet setup;
the code provider should point that out to you.

At that point it's ready to be used via Tools -- Macro -- Macros from the
regular Excel menu.

Subs that start with
Sub Worksheet_??????
or
Sub Workbook_?????
(where ????? are some more words) have to go into other areas of the .xls
file. But what I explained above will work with most Sub and Function code
segments provided here.


"oceankayakjim" wrote:

Thanks!

I'm a bit new to Excel, (I'm a misplaced Mechical Engineer), I'll show this
to the IT department here and see if they can help me with this.

--
oceankayakjim


"Don Guillett" wrote:

Sub eachshape()
For Each sh In Sheets("yoursheetnamehere").Shapes
MsgBox sh.Name
MsgBox sh.TopLeftCell.Address

'sh.cut ' to delete automatically

Next sh

End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"oceankayakjim" wrote in message
...
Hi

I am using Excel 2003 and have a question about Pictures. I have been
given
a Excel file to maintain for daily meetings. The problem is that it is
full
of "Picture Boxes". These Boxes are empty, but they take up space and slow
the file to a crawl. I have gone in and manualy deleted all the "Picture
Boxes" that I can find. The file is now 87.6% smaller. I am sure that
there
are more "Picture Boxes". Is there a way to find them without fishing?
--
oceankayakjim





  #6   Report Post  
Old May 11th 09, 02:38 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 6
Default Deleteing Pictures

Thanks to everyone.

You have helped me bring a file from 4,397KB down to 164KB.
This decrease in size has resulted in an increase in speed.
All the Production Supervisors are thrilled. Waiting for this report has
been an on going problem.

--
oceankayakjim


"Ken Wright" wrote:

Edit / Go To / Special / Objects - Then hit the delete button

Regards
Ken.............................


"oceankayakjim" wrote in message
...
Hi

I am using Excel 2003 and have a question about Pictures. I have been
given
a Excel file to maintain for daily meetings. The problem is that it is
full
of "Picture Boxes". These Boxes are empty, but they take up space and slow
the file to a crawl. I have gone in and manualy deleted all the "Picture
Boxes" that I can find. The file is now 87.6% smaller. I am sure that
there
are more "Picture Boxes". Is there a way to find them without fishing?
--
oceankayakjim






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
deleteing objects Debi Excel Discussion (Misc queries) 2 January 16th 07 06:25 PM
deleteing documents Gildee New Users to Excel 1 November 8th 06 09:31 AM
Deleteing koba Excel Discussion (Misc queries) 2 November 25th 05 04:11 AM
deleteing duplicates syssupspe Excel Discussion (Misc queries) 2 April 28th 05 12:15 AM
Deleteing some Rows Deepwater Excel Discussion (Misc queries) 1 April 1st 05 06:23 PM


All times are GMT +1. The time now is 01:09 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017