Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to edit cells over background picture in Excel 2003
I would like to use a picture as a background and edit cells over or under
it, I have set transparencies and used send to back options with no luck, I prefer to avoid using the watermark option for lack of versatility. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to edit cells over background picture in Excel 2003
I don't know if this will be of any help, but since no one else has
responded, here goes: You can get to any cell by using Goto. Then use the arrow keys to move around, not the mouse. Problem is, of course, you can't really see what you're working on except that the contents of the selected cell will show in the formulabar. (Pressing F2 will show the contents through the picture.) Or, it might be worthwhile to paste this little macro into a standard module and assign a shortcut key to it to so you can toggle the picture's visible property on and off. First, click on the picture and look at its name on the left side of the formulabar to make sure it really is named "Picture 1". If not, change its name in the code. Maybe of some help unless someone else has an idea. James Sub PixVis() With ActiveSheet.Shapes("Picture 1") .Visible = Not .Visible End With End Sub "Athon1" wrote in message ... I would like to use a picture as a background and edit cells over or under it, I have set transparencies and used send to back options with no luck, I prefer to avoid using the watermark option for lack of versatility. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to edit cells over background picture in Excel 2003
Here's how --
Insert the picture as a jpeg or bitmap. Open the 'picture' toolbar, and click on the 'set transparent color' icon. Then click on the color you want to become transparent, and you're good to go. You can't type into cells through the picture, but you can see where they are, get them aligned, and then move the picture, do your work, and move it back. HTH "Zone" wrote: I don't know if this will be of any help, but since no one else has responded, here goes: You can get to any cell by using Goto. Then use the arrow keys to move around, not the mouse. Problem is, of course, you can't really see what you're working on except that the contents of the selected cell will show in the formulabar. (Pressing F2 will show the contents through the picture.) Or, it might be worthwhile to paste this little macro into a standard module and assign a shortcut key to it to so you can toggle the picture's visible property on and off. First, click on the picture and look at its name on the left side of the formulabar to make sure it really is named "Picture 1". If not, change its name in the code. Maybe of some help unless someone else has an idea. James Sub PixVis() With ActiveSheet.Shapes("Picture 1") .Visible = Not .Visible End With End Sub "Athon1" wrote in message ... I would like to use a picture as a background and edit cells over or under it, I have set transparencies and used send to back options with no luck, I prefer to avoid using the watermark option for lack of versatility. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I set a picture to be a background in excel | Excel Discussion (Misc queries) | |||
put a picture in the background of an excel spreadsheet? | Excel Discussion (Misc queries) | |||
Set the size of a background picture in Excel | Excel Discussion (Misc queries) | |||
Excel background picture | New Users to Excel | |||
In Excel 2000, Cannot edit cells in worksheet created in 2003? | Excel Discussion (Misc queries) |