Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with pictures in excel
Hello,
I have been reading posts here for several weeks and I am amazed at the vast wealth of knowledge out there about Excel (some of you have such great websites...!!!). I have used Excel for years and only recently decided to try to learn VBA. I was wondering if someone out there could possibly help me with a problem? I have a project where I would like to have several pictures that will be available in all the workbooks created from my template that can be opened either in a userform or on a worksheet and can be "annotated". Essentially, I want the user to be able to draw on the picture and "save it" to the worksheet. I need to keep the pictures somewhere (I thought to have them on the worksheet in layers and hidden but I would prefer not to keep all the pictures on each workbook that is created from the template, I would rather just call/create the one or two that each "user" will need in that workbook) then programmatically make them visible when called and open the drawing toolbar. The problem I have is two-fold: how to position the pictures so that they will appear in the same place no matter who opens the program (I would prefer to have them open relative to a certain cell on the sheet) and how to make them hidden and then visible. I know how to do this on a userform but I don't know how to do it on the worksheet. I have combed the 'net to see how to draw on the picture on a userform but the only reference I could find showed a macro that, while it does it well on the userform itself, was unable to draw on an image on the userform and it was also quite limited on what type of drawing could be done. Does anyone know how to accomplish any/all of what I am asking? I would very much appreciate the help. Thanks, Michelle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you export pictures from my pictures file into a word docu | New Users to Excel | |||
Storing Clip Art pictures in My Pictures folder | Excel Discussion (Misc queries) | |||
Pictures.Visible question (after adding many pictures, they stop disappearing) | Excel Programming | |||
Pictures in Excel | Excel Programming | |||
Excel's Compress Pictures or deleting pictures doesn't seem work | Excel Discussion (Misc queries) |