Unable To Delete Image Within Spreadsheet

Dec 11, 2013

I'm trying to delete images from an excel spreadsheet. She had imported several Red "X" symbols and placed them at the bottom of the spreadsheet so that she could click and drag them to various spots on the spreadsheet when needed.

Well, now wants several of the "X" symbols to be erased...the problem is that they won't simply delete and when I click to drag them they stay in the same place and give me a duplicate to drag.

EXCEL Example.xlsx

View 3 Replies


Excel 2007 :: Unable To Enter Any Data In Spreadsheet?

Apr 19, 2008

Very simple Excel 2007 spreadsheet. It consist of four columns with either numeric or alpha data in the. No formulas, no macros etc...

She emailed the spreadsheet to me and it works fine, I can enter data without problems. Whenever she tries to use it she just can't enter any data. She clicks in a cell and it highlights but she doesn't get a cursor and can't enter data. If she tries to click in the area underneath the toolbar to enter data she also does not get a cursor!! It used to work just fine for her but has suddenly stopped!

View 5 Replies View Related

Error In Data Validation - Unable To Load Spreadsheet?

Sep 4, 2013

Error in data validation: "A named range you specified cannot be found." However, the named ranges are in the Name Manager, and if I go to the sheet and select the range, I can see it is already named.

Full description:

I created a spreadsheet model (no VBA, just formulas, etc) in a workbook that another coworker took and added VBA to. However, he was not working with the most updated version. So last night I checked the sheets which had the same names, made sure there were no differences except the changes I had made since that version, and then moved the ones from my current workbook into his workbook.

On the sheet where the user was to input details of the report, there are 4 cells that each contain different lists (non-dependent). I want the user to only be able to choose one of the 4 drop down menus - that is, if any of the 4 cells are filled in, I would like the other 3 to default to N/A (or somehow not be allowed to be chosen). This was solved in a previous thread:

Using A1: =IF(COUNTA(A2:A4),NA(),G2:G6) from the other thread solution, I used a named range instead of G2:G6 and it worked well.

When I merged the files together, the 4 cells no longer worked at all. It was suggested that I look at the Name Manager, and some of te named ranges I had were in there multiple times. I cleaned them up.

I tried to enter the same formula again, and it gave me the specific error: "A named range you specified cannot be found." However, the named ranges are in the Name Manager, and if I go to the sheet and select the range, I can see it is already named.

I am unable to load the spreadsheet due to sensitive data, and removing the data would make the workbook make no sense.

View 6 Replies View Related

Possible To Save Areas Of Spreadsheet As Image Files Via VBA?

Sep 27, 2013

I produce spreadsheets which is conditionally formatted to be both functional and aesthetically pleasing. The tables are separated by one line, and can easily be defined by VBA, I was wondering if it is be possible to export them as image files via vba? I know it can be done for graphs, but not sure about defined sections of the worksheet?

View 1 Replies View Related

Finding Image On Spreadsheet And Copying To Clipboard

Jul 22, 2014

Right now I have multiple sheets each with a single (different) image floating on top of the cells as all images do in excel.

What I would like to achieve is when a certain sheet is activated, the code finds the image on that sheet and then copies it to the clipboard. What would be a way to go about this?

I have done some research trying to understand how images are referenced in excel.

View 1 Replies View Related

Exporting Data From Spreadsheet Into Image IPTC Fields

Mar 19, 2008

Any way to export information from an Excel spreadsheet and import it into the IPTC / EXIF files of images? (e.g. there will be an image called 12345.jpg, and in the spreadsheet there will be the number 12345.jpg and some caption, keyword etc. data to import.

View 2 Replies View Related

Unable To Delete Or Edit Comments

Feb 9, 2009

I have a comment which I wish to edit, but I am unable to either edit or delete the comment. I have checked the 'shared workbook', 'shared worksheet', and 'protected cell' options and they are all turned off (never had them on).

The cell I have the comment on has a dropdown box, but I can't see that being a problem. I am able to add a comment, which I can edit and delete, but the original comment seems to be 'stuck'.

View 3 Replies View Related

Unable To Delete 1 Million+ Rows

Apr 30, 2009

I've accidentally created over 1 million rows across several sheets which has sent my file size over 35mb.

I desperately need to delete these and cannot find any way of doing so.

They were created through macros copying columns and pasting them elsewhere, although I'm not sure how they decided that 4-800 rows of data was worth a million rows.

Can anyone offer a solution that doesn't entail making a new sheet and rewriting all the forumula's in it?

View 9 Replies View Related

How To Delete Image By Macro

Aug 17, 2014

I'm using following code to delete some image called "Dev_Graph"

Sub Del_Graph()
' Del_Graph Macro
Sheets("Report").Unprotect Password:="1234"
Sheets("Report").Protect Password:="1234"
End Sub

the problem is, If i run this macro when there is no Image, i got a error msg.

View 3 Replies View Related

Excel 2010 :: Unable To Delete Rows

May 30, 2014

I'm on mac Excel 2010 and i'm trying to delete rows..but for some reason they don't go! My workbook is a basic one, just filled with a bunch of formulas, i can't understand why it wont let me delete it.

When i do try to delete it, nothing comes happens and when i try to delete a large amount it comes up with 'not enough memory, continue without undo deleting rows' but my laptop has 8GB and my other laptop has 16GB so i can't see why a 16GB laptop wouldn't be able to delete it.

View 1 Replies View Related

Unable To Hide Columns/delete Values Using Combo Box

Apr 24, 2007

Using two Combo Boxes, I am trying to create an drop down outline form input sheet.

What it does is if you select the first selection in the combo box 1, then it hides certain rows, and deletes certain cells. If you select the second option in the combo box 1, it shows another combo box (2) which has another list of categories.

When I select the option 2 on the combo box 1, it unhides a bunch of rows, and activates combo box 2. However, when I try to select categories on combo box 2, each time it tries to hide/unhide rows I get this message "Unable to set the hidden property of the range class." I have no idea whats going on.

Here is my ....

View 9 Replies View Related

Delete/Remove Picture From Image Control

May 15, 2008

I want to delete a picture from an image control in a worksheet when pressing a button. So my code is:

Private Sub CommandButton1_Click()
Sheets("Sheet1").Image1.Picture = LoadPicture("")
End Sub

Well, the problem is that this code only works when I create it. If I save and close the excel file when I open it again and I press the CommandButton1 I get the following error: Run-time error '-2147417848(80010108)' Method "Picture of object "IImage" failed.

View 6 Replies View Related

Excel 2010 :: Unable To Right Click For Format Cells - Insert Or Delete

Sep 27, 2011

Just recently My Excel 2010 has decided to not let me right click to format cells, delete or insert rows. I can do these functions from the ribbon, but not via right click. this happens in both existing spreadsheets where I am the author, or even a brand new spreadsheet like in the image below. we have restarted the computer, Uninstall and reinstalled Office and still get same symptoms. I got here thru google but cannot find an answer anywhere.

I am very computer literate and even our IT personnel have looked at this with no answer. as you can see in the image, these options are greyed out.

Running Office standard 2010, Windows 7 pro x64

View 8 Replies View Related

Linking Image To Cell Value And Display Selected Image In New Sheet?

Mar 18, 2014

I need to link an image to a cell value and display the selected image in a new sheet of the same excel. I am attaching samplefile for easy reference. The requirement is, from the workout sheet when I select from drop down list, then the corresponding cell value appears in Parameter sheet in C9 cell.

There are four images copied in Parameter excel. The given image has to be selected and linked to the C9 cell value. Based on the selection that particular image should be shown on Sample Picture sheet. Here based on the selection only the image should reflect here.

View 12 Replies View Related

Excel 2010 :: How To Insert Path Of Image Rather Than Actual Image Itself

Nov 4, 2013

I need to find an easy way to locate an image on my server and upon selection rather than inserting the actual image I need to insert the image path. e.g. "s:imageshighresgreen1234.jpg"

View 3 Replies View Related

Dynamically Updating Image (ActiveX Image Control)

Oct 26, 2011

My workbook simply has multiple columns of data which will be summarized visually in a tag cloud (I have the tag cloud part taken care of already creating either a jpg or png, I simply have to change the extension within a batch file to change between picture formats)

I need to have the tag cloud image display and update depending on which column the user would like to summarize (for now I have simplified the issue by only having one of the data columns in my workbook, and will worry about the user selection of the data column to be summarized later).

My Main Question:

Focusing on the image display and updating now, whether it be an ActiveX Image Control or any other way. I've been playing around manually before I try and code it and I can not get either a jpg or png file to attach to the ActiveX control (both of which cause an Invalid Picture Message).

The file name can stay the same if need be and for now I think/assume that'd be easiest (I have my Tag cloud generator just replacing the previously existing image file of the same name).

Would ActiveX control be the way to go for this dynamically changing image?

View 9 Replies View Related

How To Automatically Identify Image Name And Place In Cell Next To Image

Jan 22, 2014

I am looking for a way to take the picture name associated with an image ie: (picture 571) and place that picture name in the cell next to the image.

I can see the picture name - it registers in the top left box that usually indicates the cell the cursor is on... and I could manually type that name next to each image.

However my spreadsheet has several thousand rows- each with several columns of information and an image..

I am looking for a way "formula?" to automatically read the image in cell J4 and populate cell K4 with the image name... and so on.

The reason for my request... is I am importing products into a web based shopping cart... to do so I have to export the products to a csv and import that csv into the shopping cart. The process of exporting to a csv- strips away all the images and leaves just data.

I found that I can save the document as an html and that process creates a folder with all the images- saved as (picture 571.jpg) if the resulting csv had the image name... the shopping cart would then look for that image name in my image file and it would populate into the shopping cart appropriately.

This seemed on it's face like a really simple thing to do, I have plenty experience with excel & I thought I'd be able to make cell k4= j4 and tada it would glean the image name & I could simply copy that formula all the way down the sheet & it would be done... but I just cant find the magic button that freely gives up the image name...

View 5 Replies View Related

Embed Image In Cell :: HTTPS URL To An Image

Aug 8, 2006

I have a dataset that includes the path and optionally an HTTPS URL to an image. Is it possible to embed this image in a cell?

Short of that what might be some other options?

View 11 Replies View Related

Is There A Way When Type Image Name In Textbox It Load Out That Image

Oct 9, 2007

is there a way to load an image out when u type the image name in the textfield.
Example when I type in my name it load my image out beside the name.

View 14 Replies View Related

Grabbing Name Of Displayed Image In Image Control

Jan 22, 2012

I have a number of image controls on a user form, each being loaded with an image from file.

Image1 being loaded with a picture of a bus image2 being loaded with a picture of a school

And so on

Now what I am trying to do is when that image is clicked the name of that image is passed to a textbox

So the action would be

1 image of bus loaded into image control1 , the name of that image being bus.jpg
2 image is clicked
3 the name bus.jpg appears in a text box

Here is what I have so far


Private Sub Image1_Click()
DataInput.TextBoxItem.Value = bus.jpg

DataInput.TextBoxItem.Value= Image1.Name - this does not work

End Sub

Which works but as you can see this is static, as I have supplied the value , were as I would like the clicking action to pick up the name of the jpeg being displayed

So expanding upon this if say image1 is loaded with say a picture of a car instead of a bus

LValue4 = "E:Car.jpg"

Image1.Picture = LoadPicture(LValue4)

Now when it is clicked the name of the image being displayed in image control1 would be Car.jpg

And it is this value I wish to transfer to a text box for now will do more with it later

In addition to this I am not sure if the best idea is to have a number of image controls and load each with an individual picture or have one image control and swap the picture by clicking a command button

View 3 Replies View Related

Display Image Based On Image Name In Cell

Sep 4, 2007

Is there a way to have image box display an image with a name matching data from a cell? example: if I type "hello" in cell a1, Image box will load image named "hello". And display new images by changing the name in cell a1. Note: the images will be located in a permanent folder.

View 3 Replies View Related

Delete Records From Spreadsheet

Jun 29, 2009

I have some data that looks like this.

No. Date
1519 06/17/2003
1652 06/30/2005

What I would like to do is delete all numbers including those with duplicates that have a date of 2004 or sooner. In otherwords, anything from 12/31/2003 and later I want to keep, but anything from 01/01/2004 until the present.

View 9 Replies View Related

Delete Every Nth Column From A Very Large Spreadsheet

Mar 12, 2009

I have created a sample spreadsheet (the real data is sensitive) but I am basically faced with a spreadsheet of many columns of which I would like to remove the 4th,5th, 8th,9th, 12th, 13th etc...

So every 3rd column starting from Column B, and also every 3rd starting from Column C, (every 3rd, and every 3rd + 1 starting from B?), it's obvious what I'm after from the spreadsheet I've provided.

Unfortunately manually isn't an option, this needs doing every week, and it goes all the way across to column HZ!

View 2 Replies View Related

Iteratively Delete Rows From A Spreadsheet

Apr 13, 2009

I have a very large spreadsheet (about 50,000 rows, and to CM of columns) with blocks of data 20 rows high (rows 1-20 are from Building A, rows 21-40 are from Building B, etc). However, not every row in each block of 20 has information in it - some are just placeholders. For example, some blocks may have rows 1-18 filled with data while other blocks may have only 1-6 filled with data. I am interested in programming a macro that would delete the placeholder rows out of the spreadsheet based on a certain criteria. This would probably halve the size of my spreadsheet.

In faux-
For row i
i = 1 to 50,000
If Column B = #NA
Delete row i

Is this something that can be done with a macro, or do I need to go through all of these rows by hand? Obviously, I haven't programmed macros before (I've taken code and run it), but I've programmed in other languages (Java, C#). Could someone point me in the right direction?

View 4 Replies View Related

Users Of The Spreadsheet Cannot Delete The Formula

Feb 6, 2009

I have this formula in my worksheet

=sum (L12*M12*N12)

How can i put this formula into VB code so that users of the spreadsheet cannot delete the formula.

View 9 Replies View Related

Delete Off All Blank Rows In A Spreadsheet

Jul 20, 2006

How can I delete all blank rows in a spreadsheet without sorting the data as I want it to be in the exact order it is in.

View 5 Replies View Related

Add Image To Worksheet Image Control

Jan 14, 2008

I am trying to display an image ("image") on an image control ("Image1") placed in a worksheet ("Sheet1"). The problem is that I want this action to take place when I press a button in a user form. I am trying to use the following code, but it seems that VBA does not recognize the image control ("Image1") in the worksheet.

Private Sub cmdDisplayImage_Click()
Dim image As Variant
image = ThisWorkbook.Path & "sun.jpg"
Image1.Picture = LoadPicture(image)
End Sub

View 2 Replies View Related

Automatically Delete (or Hide) Columns In Spreadsheet?

May 15, 2014

how to automatically delete (or hide) columns in a spreadsheet given a list of columns that I want to retain (or see).

These are the columns I want to retain (or see):

1st Phone Number
2nd Phone
Email Address
Enrollment Status
Room not available
Mailing address
Payment Record
Payment Status
Requested room type
Total Payments to Date
What is your meal preference?

The attached has two tabs......columns I want to retain (or see) and the raw data of all the columns.

View 1 Replies View Related

Looping Macro (delete Every Other Line On A Spreadsheet)

Jan 16, 2010

How do I write a macro that will delete every other line on a spreadsheet? I can create a macro that delete one line using the Record a macro command but what do I ad at the end of the macro to keep it going until stopped with Ctrl Break?

View 13 Replies View Related

Delete All Text Boxes In A Spreadsheet/Workbook

Jun 16, 2008

I have a spreadsheet with over 20 tabs - each containing 6 text boxes containing financial commentary. Each month, the tabs are 'overpasted' with the latest month equivalents. This results in the latest month's text boxes sitting on top of the previous month's. I would like to attach functionality that deletes all the text boxes at the start of the monthly cycle - so the 'overpasting' exercise starts with a spreadsheet that contains no text boxes. I have been unsuccessfull with my attempts because each text box has a unique number - which changes every month. Does any VBA script exist to delete all the text boxes in a workbook or tab?

For reasons that are too longwinded to go into, there is no way around the overpasting set-up as summarised above (I recognise this is far from the ideal solution).

View 8 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved