Inserting Picture in protected sheet
 

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.

Inserting Picture in protected sheet
 

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


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


"JackR" wrote in message
...
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.

Inserting Picture in protected sheet
 

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


"JackR" wrote:

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.

Inserting Picture in protected sheet
 

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

"Ron Coderre" wrote:

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


"JackR" wrote:

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.

Inserting Picture in protected sheet
 

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 (ToolsOptionsViewUncheck: 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 EditCopy Picture
Check: As shown on screen
Check: Picture
Click the [OK] button

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


"JackR" wrote:

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

"Ron Coderre" wrote:

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


"JackR" wrote:

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.

Inserting Picture in protected sheet
 

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

Jack R

"Ron Coderre" wrote:

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 (ToolsOptionsViewUncheck: 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 EditCopy Picture
Check: As shown on screen
Check: Picture
Click the [OK] button

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


"JackR" wrote:

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

"Ron Coderre" wrote:

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


"JackR" wrote:

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.

Inserting Picture in protected sheet
 

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

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

XL2002, WinXP-Pro


"JackR" wrote:

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

Jack R

"Ron Coderre" wrote:

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 (ToolsOptionsViewUncheck: 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 EditCopy Picture
Check: As shown on screen
Check: Picture
Click the [OK] button

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


"JackR" wrote:

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

"Ron Coderre" wrote:

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


"JackR" wrote:

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.