| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic background image in Excel?
On Feb 1, 8:21*am, Luke M wrote:
You are correct, it will require a macro. You can make it so that the picture is changed when you open the workbook, you can do the following. Open up the VBE by right-clicking on the sheet tab, view code. In the project navigation window (if not visible, check under View) navigate to the ThisWorkbook module. Paste this in, and edit the appropriate lines: '============ Private Sub Workbook_Open() * * 'Tell the macro which sheet to work with * * Sheets("Sheet1").ChartObjects("Chart 1").Activate * * With ActiveChart.PlotArea * * 'Which picture file to use? * * .Fill.UserPicture PictureFile:= _ * * * * "C:\My Documents\My Pictures\My picture.bmp" * * .Fill.Visible = True * * End With End Sub '============= -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* Thank you, Luke. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to restrict a repeating background image in Excel sheet ? | Excel Discussion (Misc queries) | |||
| Using a Word, PDF, Image as a background on Excel. | Charts and Charting in Excel | |||
| Excel background image | Excel Discussion (Misc queries) | |||
| How do I get the print of the background image of excel? | Excel Worksheet Functions | |||
| Form-filling application with Excel (background image)? | Excel Discussion (Misc queries) | |||
Threaded Mode
