Hi all

I need some help (I'm not very good with VB):

I'd like to have a command button within my spreadsheet that whe
clicked on opens up the INSERT PICTURE FROM FILE dialogue box, whic
then allows a user to select a picture then click OK.

Sounds easy? Well the problem is that the spreadsheet is going to b
password protected. Therefore the command button needs to:

1. When clicked on automatically unprotect the spreadsheet (by secretl
inserting the password - i.e. without the users seeing what it is)
2. Open up the INSERT PICTURE FROM FILE dialogue box
3. Allow a user to find their pic and click OK (go to 4)
3a. If the user clicks cancel go to 4
4. Close the dialogue box and automatically re-protect th
spreadsheet.
5. Allow the user to re-size and drag the picture around to where the
want it.

Is this possible?? I really want the spreadsheet protected as there ar
certain control boxes and nested IF's that I don't want the user to b
able to alter, but one of the key features is that they are to be abl
to enter a picture into the sheet.

Thank you for all your hel

--
Message posted from http://www.ExcelForum.com