Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / April 2007

Tip: Looking for answers? Try searching our database.

Insert photo into a protected worksheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul Kouri - 02 Mar 2007 22:56 GMT
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 - 02 Mar 2007 23:03 GMT
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.
Signature

-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.

> 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
Paul Kouri - 02 Mar 2007 23:36 GMT
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.

> 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.
[quoted text clipped - 5 lines]
> > text as well as microsoft forums and can't find a similar instance.
> > Paul
Wei Lu [MSFT] - 10 Apr 2007 07:57 GMT
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] - 12 Apr 2007 11:15 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.