+ Reply to Thread
Results 1 to 2 of 2

How can I insert pictures into a protected worksheet?

  1. #1
    Registered User
    Join Date
    09-07-2010
    Location
    uk
    MS-Off Ver
    Excel 2003
    Posts
    15

    How can I insert pictures into a protected worksheet?

    I have a protected worksheet, but I want to allow users to insert and resize pictures into it.
    Anyone got any ideas on how to do this?
    Test file attached.
    Many Thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-07-2010
    Location
    uk
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: How can I insert pictures into a protected worksheet?

    I have found one solution, but the files must be .bmp, i need it to accept .jpg as well.
    -When you protect the worksheet, make sure you tick the box 'Edit objects'.
    -Go to 'Insert'-'Object'-'Create from file'-'Browse', and select your .bmp
    -Press 'OK'

    I need to put .jpg files in though. Any ideas?
    Last edited by vinokirk; 09-01-2011 at 06:23 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1