Hello all,
Does anyone know a way to reference a cell location for a logo and have it dynamically change to selected cells throughout workbook. The cells may be different on the various worksheets.
Hello all,
Does anyone know a way to reference a cell location for a logo and have it dynamically change to selected cells throughout workbook. The cells may be different on the various worksheets.
I am presuming the logo is an image/picture and not text entered into the cell?
If its an image (pasted in or from a file) then it cannot be referenced as far as I know. Objects like images and drawing objects "float" above the cells on the sheet and do not behave like cell contents (text, numbers, formulas, etc). So with something like an image your only option is to copy/insert it on each sheet you want it on and/or create a template that includes it.
If the "logo" is really just formatted text/content in a cell then you can reference it just like any other cell, however I doubt this is what you mean.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
It will be a picture of some sort.
Hm, it's same question as below.
https://www.excelforum.com/excel-gen...ml#post4822188
Didn't my solution work for you? Or using Camera tool?
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Oh I forgot I put that post sorry. I tried the camera method but it isn't what I intended. I will manually set the logos in the workbook.
Sorry again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks