Insert photo into a protected worksheet

[Paul Kouri]

I have created a worksheet with protected and unprotected cells. I have
created a area C2:J10 as an area for the user to post a picture. However
when the worksheet is protected the option is grayed out. Is there a way to
insert a photo into a protected sheet? I've spent hours researching the help
text as well as microsoft forums and can't find a similar instance.
Paul

 

[John Bundy]

I'm pretty sure this can not be done with just protection, you would have to
create a macro that would unprotect the sheet then reprotect it.

 

[Paul Kouri]

John, Thanks for your rapid response.
I read this in several areas but no place describes step by step as to how
to create a macro that does this. It would be really great if the user could
click an icon within the sheet that would launch all this to happen. In
other words, click the area where the picture should go and the macro
launches. Do you know how to or where this can be found as to how to do.

 

[Wei Lu [MSFT]]

Hello Paul,

I think the most efficent way is to record the Macro.

On the Excel Menu -> Tools ->Macro -> Record New Marcos. Then, you could do
all the operation you want. Like unprotect the sheet, insert the picture
and then protect the sheet again.

All the operation will be recorded. After that, you could run the marco to
do these.

Hope this helps!

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

 

[Wei Lu [MSFT]]

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.