how put picture into cell as background. it means, after it's done, if i click on cell, i must be able write into cell like before change. i dont want solution through comments or shapes because picture will be on top of cell. and not as background
View 7 RepliesCan you Put a picture as a background for a cell?
View 1 Replies View RelatedI have a dropdown box with a few options in it. What I want to do, is have excel load a particular picture, that I have saved on my computer, into the background when a certain option is selected from the dropdown box.
View 9 Replies View RelatedMy macro generates some graph from some datas. Datas are in some range and when I filtering it shows only filtered values. I use Fixed axis (min and max) because if I use Auto it fit data to the window.
My problem is: I would like to use Auto axis because my layout would be better but bacground picture remains the same and it's useless. Background picture should change as I change filters.
example:
untitled.JPG
here is picture:
current situation is 1.
With Auto axis I get 2. (blue B and green D are filtered results)
And I would like to have 3.
Is it possible that background picture variate as datas variates?
how to correct the tiling of a picture set as a background on a worksheet? It would appear to start tiling at b2 rather than a1. the bottom of the picture starts on row 1 and the top of the picture then begins row 2. also column a shows the far right side of the picture and column b shows the start of the left side.
View 2 Replies View RelatedI want to add an image to a sheet. The image is to print but I want the data from that sheet to go over the top. I can't seem to get the image behind my data.
View 6 Replies View RelatedI need to add a background picture to a spreadsheet that only shows on the print area.
This spreadsheet is being used as a pro forma invoice that can be emailed to customers for them to view & print as required.
At the moment I can add a background image but this appears throughout the sheet and not in the place I need it to i.e. the print area.
I'm trying to make a map of 14 regions where each region changes brightness depending on values in the worksheets. I think I've got this bit sorted. I'm planning on creating the map using a collection of tessellated shapes or images, and using VBA to alter the properties of each one to create a dynamic map.
The output of the individual maps from MapInfo, our GIS software, is in .png or .jpg. format, and come with a white background. Is there any way to either make the background transparent so multiple shapes can be tessellated effectively, or a way to crop the image to the area's border?
Either that, or does someone know a way to output from MapInfo in such a way to make this possible? (Granted, it's a long shot, but you can't blame a guy for trying...)
I want to have a sample file in excel which store picture of student in comment, I did this, but when I want to insert picture the file dialog appears, and if I click cancel, then there is an error, why? If some one optimise the code it would be very nice
View 6 Replies View RelatedHow do I do this?
View 3 Replies View RelatedI am working on a workbook with 200+ sheets and an index linking to each of the sheets. On the sheets there is a cell containing the results of calculations and I need the cell referencing the sheet in the index to change background colors depending if the calculations value is greater or less than 0. I currently have working code that also changes the tab color of each sheet depending on the value, but i am trying to add the index cell background change functionality into that. also, the index listings is subject to change. my working code is
VB:
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("d34").Value < 0 Then
Me.Tab.ColorIndex = 3
ElseIf Range("D34").Value > 0 Then
Me.Tab.ColorIndex = 4
Else
[Code]...
and the code i am trying to get working is
VB:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngX As Range
Set myRange = Worksheets("Index").Range("A1:A500").Find(Range("C2").Text, lookat:=xlPart)
' the C2 is the reference the title that would be on the index
If Range("d40").Value < 0 Then
[Code]....
I keep getting the runtime error '1004: application-defined error or object-defined error the thing is, i ran the cell background changing code in a normal macro before integrating it in my other worksheet code first and it worked fine. I have a little code experience, though not much in vba and I am unsure what the issue is. if there is another better way to accomplish what I'm tring to do, that would also be fine.
Excel 2007 I have 80 very similar sheets. The only difference is the sheet name (Phase A (1), Phase A (2) etc.). I want the formula located in cell B5 to be different on every sheet.
I have listed the desired formulas on a single seperate worksheet, named "Overview". On this sheet, the following columns have these data in them:
A - Sheetname (example: Phase A (1), Phase A (2) etc.)
B - Cell location (example B5, constant)
C - A formula (example: =Sheet1!G47, =Sheet1!G48, etc.)
I would like to create a macro that will loop through all the sheets, doing the following:
1. Check if the sheetname exists in column A of the Overview sheet
2. If it does, take the formula from column C of the Overview sheet
3. And put it in the cell specified in column B of the Overview sheet
Here is some code, to illustrate the above. I know the code is mostly nonsensical.
Code:
Sub Enter_formulas()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
[Code]....
I have done the above where when I select a picture name from a drop down list it displays the relevant picture in another cell by using the IF function in the named formula
My question is why cant I use VLOOKUP instead of IF in the named formula. When I use it it comes with an error.
I want to paste/show a photo in a particular cell (D2) on a worksheet (called PP). I wish to delete any photo that may already be there in D2.
The picture's name (e.g. J-145.jpg) will be found in another sheet (called MP) in cell H1.
My pictures are stored in a folder (lets call it c:pictures) and the one I want has the same name (J-145.jpg).
I've tried many macros but none work.
i have saved some pictures in my excel sheet.
in the next sheet i want that when i write the picture name the picture will appear as vlookup helps in the getting text and nos. can i do this with pictures or i tried to get to much from excel.
How can i get this code to run through each sheet and place the value of the sum on its respective sheet in the same positon .....
Sub maths()
lr = Cells(Rows.Count, "E").End(xlUp).Row
Range("E" & lr + 1).Select
ActiveCell.Formula = Application.WorksheetFunction.Sum(Range("E2:E" & lr))
Selection.NumberFormat = "[h]:mm:ss"
End Sub
In a range of cells (A1..d8) which have background set with multiple colors. Is it possible to set another range of cells (H1..K8) whith the same backgrounds as the other range and so that if one cells background changes the cell in the second range whill also change to that new color?
View 11 Replies View RelatedI'm trying to put the image in the background by doing 'Format - Sheet - Background'
but the image become tiles instead of one.
I want the image in the background so I can edit cells with formulas on top of the image. Is there any way of manupilate the background image with Macro so I can have just on image instead of tiles?
I've done watermark but that's only available in preview. I'm using Excel 2003
How can I set up my sheets so that the background and grid are isolated, in other words only the background, the grid, and my data shows on the sheet, the rest will be blacked out. I need to email only the certain area of the worksheets.
View 3 Replies View RelatedIs there anyway to put a background on a worksheet, without the file size of the workbook becoming monstrously huge? I have a small jpg file of our company logo, and I think that it would be a nice touch for it to be the background to our spreadsheet. But when I use this 50k file as the background, the workbook suddenly grows to a size of 7MB.
View 4 Replies View Related"DRHannay" wrote:
> how do I place the sheet tab name in my spreadsheet by formula?
>
> Excel 2003
Try:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
I need to copy the sheet being worked on, and place it behind the original sheet.
This is going to be in a Macro enabled template that other users will be rename when they save it.
It will be activated by a button on the original worksheet other users may need to rename the worksheet before copying so I am using ActiveSheet.Copy I don't want to put the sheet after a counted sheet, because other sheets may be inserted before the one being worked on. I am not proficient at VB, I basically search for a macro that does what I need and copy it.
This is what I am working on.
Sub CopySSR()
'
' CopySSR Macro
'
'
ActiveSheet.Copy After:=Sheets(7)
End Sub
I have is 3 seperate jobs listed, what i want to do is have each one of these rows copy over to a different sheet, and place the next available row. What I would like to drive this is the number in column "n", for example, "n3" is 1, so I would like that row to copy to the sheet named "1", and entered in the next available row under any previous lines that have been copied over.
******** ******************** ************************************************************************>Microsoft Excel - BETA SCHEDULE.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA1=ABCDEFGHIJKLMNOP1Date EnteredTime Ent'dCUSTOMERJOB #LINE #MATERIALMATERIALMAT'L QTYPAPERPAPER QTYFinish QNTYSIZEMach.RUN DATEDue Date233/318:58 AMCUST. A2585271HSS5260 15 SH 15 / 1530X65 .02013/313/3143/318:58 AMCUST. B2585241PC 8256 7 FT 3 / 624X26 .01023/313/3153/318:58 AMCUST. C2585161TFS1010 3178 FT 615 / 61532X61.5 .00833/314/1MASTER [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
I'm working with a very large spreadsheet which has somehow divided itself into print areas. Each section has 'Page 1' or the equivalent as a background, behind the data itself. I thought it would be simple to remove this, but for the life of me I can't see how. I'm using Excel 2007.
View 6 Replies View RelatedI have a spreadsheet that was given to me from an outside source, and a lot but not all of the cells (seem to be random) have links associated with them so that if you click a cell, it opens a new internet browser window directing to the link. Is there a way for me to remove every single one of these links without having to go cell by cell looking for each one ?
View 2 Replies View RelatedI am after a macro to do the following, my visual basic skills are very limited (non existant):- Look at the date in cell A1 on Sheet 'Live Report' and err 'remember it' Copy a range of cells from A3 to A10 on 'Live Report' Go to sheet 'Monthly Summary' and find the date that had been remembered previously (this date will be in column A on 'Monthly Summary' which will probably be a mixture of values and formulas). After the date has been found paste special and transpose the 'values only' copied range from 'Live Report' (A3 to A10) in column B on 'Monthly Summary' next to the date that has been found in Column A.
View 2 Replies View RelatedI am trying to place the contents of an array into a column on the sheet. I can enter the array into 1 cell (which strings the values), but I can't seem to make range(1)=array(1).
View 9 Replies View RelatedFound several items close to this, but not exactly (at least that I could find). It's difficult to type what I need to do, but here it goes.
I have two sheets. Sheet1 has data that I want to look at in range A1:B7; Sheet2 has column titles waiting on data from Sheet1. If one of the column titles on Sheet2 is "Mike," I need to look for all "Mikes" from A1:B7 and pull the data automatically onto the other sheet. I apologize if confusing, but I tried as best I could to describe it. I have attached a small file for guidance. Using the attached file, take "Mike" for example. Under his name on Sheet 2, cell A2 would display 300, then cell A3 would display 1,000.
I want to copy one picture from sheet one to sheet two. I just know the location of this picture.
I have come up the code below. It imports contact information from Outlook contacts in a contact folder called Private Contacts. The below code has been copied and modified from this forum.
As it stands the macro creates a new workbook and places the data on that. What I need it to do is create a new worksheet with the name of private compare on the active workbook and then place the data on that worksheet.
[Code] .....