software

I want to let people insert a picture into a protected sheet, when I password
protect it it wont allow for a picture to be inserted. Is there a way to do
this and still protect the sheet? Any help with this ASAP would be
appreciated.No, the sheet must be unprotected to insert an image.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;JackRquot; gt; wrote in message
...
gt;I want to let people insert a picture into a protected sheet,
gt;when I password
gt; protect it it wont allow for a picture to be inserted. Is there
gt; a way to do
gt; this and still protect the sheet? Any help with this ASAP would
gt; be
gt; appreciated.
gt;
I might have an idea that could work, but I need a little more information.

Under what circumstances would they insert a picture?
Would the process be automated or would they manually select/copy/paste a
picture?
Would they need to put more than one picture in the sheet?
Would it/they always be located in the same place in the sheet?

***********
Regards,
Ron

XL2002, WinXP-Proquot;JackRquot; wrote:

gt; I want to let people insert a picture into a protected sheet, when I password
gt; protect it it wont allow for a picture to be inserted. Is there a way to do
gt; this and still protect the sheet? Any help with this ASAP would be
gt; appreciated.
gt;

The sheets are for recipes for a manual I am building, as foolows;

1. Each sheet is one recipe - once the recipe is entered, they would have
the option to insert a picture
2. They would need to be able to select from a folder on their computer a
picture - since they would be taking they own pictures they would save them
to this folder
3. Only 1 picture per sheet. there is an area in the worksheet where it
would go
4. Yes the same place could be used - we would need to determine the size of
the space, whcih I do have a area on the sheet to place it in it covers about
10 rows down and 5 columns across.

Any ideas would help, thank you

quot;Ron Coderrequot; wrote:

gt; I might have an idea that could work, but I need a little more information.
gt;
gt; Under what circumstances would they insert a picture?
gt; Would the process be automated or would they manually select/copy/paste a
gt; picture?
gt; Would they need to put more than one picture in the sheet?
gt; Would it/they always be located in the same place in the sheet?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;JackRquot; wrote:
gt;
gt; gt; I want to let people insert a picture into a protected sheet, when I password
gt; gt; protect it it wont allow for a picture to be inserted. Is there a way to do
gt; gt; this and still protect the sheet? Any help with this ASAP would be
gt; gt; appreciated.
gt; gt;

OK....See if you can use this....

Start with this:
A sheet name Recipe_1 will contain the recipe
A sheet named Recipe_1_Pic will contain the picture

On the Recipe_1_Pic sheet:
Turn off gridlines (Toolsgt;Optionsgt;Viewgt;Uncheck: Gridlines)
Select from A1:E10
Put a border around the range A1:E10 (just to help you identify the range)
In the Name Box (located just above the Col_A heading) type: picRecipe1 and
press [Enter]
(that creates a range named picRecipe1)

Hold down the [Shift] key and select Editgt;Copy Picture
Check: As shown on screen
Check: Picture
Click the [OK] button

Switch to the Recipe_1 sheet and select any cell.
Editgt;Paste
While the picture is still selected, type this in the formula bar: =picRecipe1
Press the [Enter] key
(that picture now displays whatever is visible in the picRecipe1 range)
Protect that sheet.

Now for the test....
Switch to the Recipe_1_Pic sheet
Insert any picture you want there.
Resize it to fit int the border around picRecipe1

Now, go look at the Recipe_1 sheet.

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Proquot;JackRquot; wrote:

gt; The sheets are for recipes for a manual I am building, as foolows;
gt;
gt; 1. Each sheet is one recipe - once the recipe is entered, they would have
gt; the option to insert a picture
gt; 2. They would need to be able to select from a folder on their computer a
gt; picture - since they would be taking they own pictures they would save them
gt; to this folder
gt; 3. Only 1 picture per sheet. there is an area in the worksheet where it
gt; would go
gt; 4. Yes the same place could be used - we would need to determine the size of
gt; the space, whcih I do have a area on the sheet to place it in it covers about
gt; 10 rows down and 5 columns across.
gt;
gt; Any ideas would help, thank you
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; I might have an idea that could work, but I need a little more information.
gt; gt;
gt; gt; Under what circumstances would they insert a picture?
gt; gt; Would the process be automated or would they manually select/copy/paste a
gt; gt; picture?
gt; gt; Would they need to put more than one picture in the sheet?
gt; gt; Would it/they always be located in the same place in the sheet?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;JackRquot; wrote:
gt; gt;
gt; gt; gt; I want to let people insert a picture into a protected sheet, when I password
gt; gt; gt; protect it it wont allow for a picture to be inserted. Is there a way to do
gt; gt; gt; this and still protect the sheet? Any help with this ASAP would be
gt; gt; gt; appreciated.
gt; gt; gt;

Ron;
That works great !! , thank you so very much.

Jack R

quot;Ron Coderrequot; wrote:

gt; OK....See if you can use this....
gt;
gt; Start with this:
gt; A sheet name Recipe_1 will contain the recipe
gt; A sheet named Recipe_1_Pic will contain the picture
gt;
gt; On the Recipe_1_Pic sheet:
gt; Turn off gridlines (Toolsgt;Optionsgt;Viewgt;Uncheck: Gridlines)
gt; Select from A1:E10
gt; Put a border around the range A1:E10 (just to help you identify the range)
gt; In the Name Box (located just above the Col_A heading) type: picRecipe1 and
gt; press [Enter]
gt; (that creates a range named picRecipe1)
gt;
gt; Hold down the [Shift] key and select Editgt;Copy Picture
gt; Check: As shown on screen
gt; Check: Picture
gt; Click the [OK] button
gt;
gt; Switch to the Recipe_1 sheet and select any cell.
gt; Editgt;Paste
gt; While the picture is still selected, type this in the formula bar: =picRecipe1
gt; Press the [Enter] key
gt; (that picture now displays whatever is visible in the picRecipe1 range)
gt; Protect that sheet.
gt;
gt; Now for the test....
gt; Switch to the Recipe_1_Pic sheet
gt; Insert any picture you want there.
gt; Resize it to fit int the border around picRecipe1
gt;
gt; Now, go look at the Recipe_1 sheet.
gt;
gt; Is that something you can work with?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;JackRquot; wrote:
gt;
gt; gt; The sheets are for recipes for a manual I am building, as foolows;
gt; gt;
gt; gt; 1. Each sheet is one recipe - once the recipe is entered, they would have
gt; gt; the option to insert a picture
gt; gt; 2. They would need to be able to select from a folder on their computer a
gt; gt; picture - since they would be taking they own pictures they would save them
gt; gt; to this folder
gt; gt; 3. Only 1 picture per sheet. there is an area in the worksheet where it
gt; gt; would go
gt; gt; 4. Yes the same place could be used - we would need to determine the size of
gt; gt; the space, whcih I do have a area on the sheet to place it in it covers about
gt; gt; 10 rows down and 5 columns across.
gt; gt;
gt; gt; Any ideas would help, thank you
gt; gt;
gt; gt; quot;Ron Coderrequot; wrote:
gt; gt;
gt; gt; gt; I might have an idea that could work, but I need a little more information.
gt; gt; gt;
gt; gt; gt; Under what circumstances would they insert a picture?
gt; gt; gt; Would the process be automated or would they manually select/copy/paste a
gt; gt; gt; picture?
gt; gt; gt; Would they need to put more than one picture in the sheet?
gt; gt; gt; Would it/they always be located in the same place in the sheet?
gt; gt; gt;
gt; gt; gt; ***********
gt; gt; gt; Regards,
gt; gt; gt; Ron
gt; gt; gt;
gt; gt; gt; XL2002, WinXP-Pro
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;JackRquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I want to let people insert a picture into a protected sheet, when I password
gt; gt; gt; gt; protect it it wont allow for a picture to be inserted. Is there a way to do
gt; gt; gt; gt; this and still protect the sheet? Any help with this ASAP would be
gt; gt; gt; gt; appreciated.
gt; gt; gt; gt;

Thanks for the feedback, Jack...I'm glad that worked for you.

***********
Regards,
Ron

XL2002, WinXP-Proquot;JackRquot; wrote:

gt; Ron;
gt; That works great !! , thank you so very much.
gt;
gt; Jack R
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; OK....See if you can use this....
gt; gt;
gt; gt; Start with this:
gt; gt; A sheet name Recipe_1 will contain the recipe
gt; gt; A sheet named Recipe_1_Pic will contain the picture
gt; gt;
gt; gt; On the Recipe_1_Pic sheet:
gt; gt; Turn off gridlines (Toolsgt;Optionsgt;Viewgt;Uncheck: Gridlines)
gt; gt; Select from A1:E10
gt; gt; Put a border around the range A1:E10 (just to help you identify the range)
gt; gt; In the Name Box (located just above the Col_A heading) type: picRecipe1 and
gt; gt; press [Enter]
gt; gt; (that creates a range named picRecipe1)
gt; gt;
gt; gt; Hold down the [Shift] key and select Editgt;Copy Picture
gt; gt; Check: As shown on screen
gt; gt; Check: Picture
gt; gt; Click the [OK] button
gt; gt;
gt; gt; Switch to the Recipe_1 sheet and select any cell.
gt; gt; Editgt;Paste
gt; gt; While the picture is still selected, type this in the formula bar: =picRecipe1
gt; gt; Press the [Enter] key
gt; gt; (that picture now displays whatever is visible in the picRecipe1 range)
gt; gt; Protect that sheet.
gt; gt;
gt; gt; Now for the test....
gt; gt; Switch to the Recipe_1_Pic sheet
gt; gt; Insert any picture you want there.
gt; gt; Resize it to fit int the border around picRecipe1
gt; gt;
gt; gt; Now, go look at the Recipe_1 sheet.
gt; gt;
gt; gt; Is that something you can work with?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;JackRquot; wrote:
gt; gt;
gt; gt; gt; The sheets are for recipes for a manual I am building, as foolows;
gt; gt; gt;
gt; gt; gt; 1. Each sheet is one recipe - once the recipe is entered, they would have
gt; gt; gt; the option to insert a picture
gt; gt; gt; 2. They would need to be able to select from a folder on their computer a
gt; gt; gt; picture - since they would be taking they own pictures they would save them
gt; gt; gt; to this folder
gt; gt; gt; 3. Only 1 picture per sheet. there is an area in the worksheet where it
gt; gt; gt; would go
gt; gt; gt; 4. Yes the same place could be used - we would need to determine the size of
gt; gt; gt; the space, whcih I do have a area on the sheet to place it in it covers about
gt; gt; gt; 10 rows down and 5 columns across.
gt; gt; gt;
gt; gt; gt; Any ideas would help, thank you
gt; gt; gt;
gt; gt; gt; quot;Ron Coderrequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I might have an idea that could work, but I need a little more information.
gt; gt; gt; gt;
gt; gt; gt; gt; Under what circumstances would they insert a picture?
gt; gt; gt; gt; Would the process be automated or would they manually select/copy/paste a
gt; gt; gt; gt; picture?
gt; gt; gt; gt; Would they need to put more than one picture in the sheet?
gt; gt; gt; gt; Would it/they always be located in the same place in the sheet?
gt; gt; gt; gt;
gt; gt; gt; gt; ***********
gt; gt; gt; gt; Regards,
gt; gt; gt; gt; Ron
gt; gt; gt; gt;
gt; gt; gt; gt; XL2002, WinXP-Pro
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;JackRquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I want to let people insert a picture into a protected sheet, when I password
gt; gt; gt; gt; gt; protect it it wont allow for a picture to be inserted. Is there a way to do
gt; gt; gt; gt; gt; this and still protect the sheet? Any help with this ASAP would be
gt; gt; gt; gt; gt; appreciated.
gt; gt; gt; gt; gt;