Inserting Picture in protected sheet

[Guest]

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.

 

[Chip Pearson]

No, the sheet must be unprotected to insert an image.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

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-Pro

 

[Guest]

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

 

[Guest]

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 (Tools>Options>View>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 Edit>Copy Picture
Check: As shown on screen
Check: Picture
Click the [OK] button

Switch to the Recipe_1 sheet and select any cell.
Edit>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-Pro

 

[Guest]

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

Jack R

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 (Tools>Options>View>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 Edit>Copy Picture
Check: As shown on screen
Check: Picture
Click the [OK] button

Switch to the Recipe_1 sheet and select any cell.
Edit>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-Pro

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

 

[Guest]

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

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

XL2002, WinXP-Pro

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

Jack R

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 (Tools>Options>View>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 Edit>Copy Picture
Check: As shown on screen
Check: Picture
Click the [OK] button

Switch to the Recipe_1 sheet and select any cell.
Edit>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-Pro

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

:

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-Pro


:

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.