Results 1 to 4 of 4

Thread: insert image into protected Excel worksheets

  1. #1
    Join Date
    Nov 2009
    Posts
    56

    insert image into protected Excel worksheets

    Hi ,
    I have created a Excel workbook containing sheets which has unlocked cells for users for inserting images into. However, the option of inserting and pasting an image is denied as the excel sheet is protected. Please guide to do this without removing the sheet protection?

  2. #2
    Join Date
    May 2008
    Posts
    4,570

    Re: insert image into protected Excel worksheets

    Hi,

    When you protect the excel sheet, you have options which allow all users of this worksheet.

    When you scroll down that list you eventually come to option "Edit Objects". check a tick by that and then protect the sheet.

    You can in actual fact protect all the cells with that option switched on, Now you can insert image and drag them in the spreadsheet.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,642

    Re: insert image into protected Excel worksheets

    for inserting image in an Excel spreadsheet, you must insert the image in a control.

    for inserting the control, select to the View menu>Toolbars>Control Toolbox .
    select the first button Design mode.
    Select the last button, then click on Microsoft Web Browser .
    After that draw a frame for receive the image.
    Make sure that the first button Design mode and the toolbar is Disable.
    Ultimately, in the VBA editor and in the window of the paper concerned paste the below code:


    Private Sub Worksheet_Activate()
    WebBrowser.Navigate "X:\ path image.GIF"
    End Sub


    Change the active page of the excel spreadsheet, and then return in the page which contains the image, for to confirm if it working.

  4. #4
    Join Date
    May 2008
    Posts
    4,831

    Re: insert image into protected Excel worksheets

    Hi ,

    Please make sure that you are following below process

    i)Select where you want to insert the picture.
    ii)select Picture from the Insert tab of the Illustrations group .
    ii)Locate the picture which you have to insert.
    iv)Double-click on the picture that which you want to insert.

Similar Threads

  1. How to insert image or picture in excel 2007?
    By Abhiraj in forum Windows Software
    Replies: 5
    Last Post: 10-10-2013, 06:25 AM
  2. Replies: 2
    Last Post: 22-01-2012, 11:59 AM
  3. Replies: 8
    Last Post: 04-12-2011, 11:24 AM
  4. cannot tab between worksheets in Excel 2007
    By MartinaMiranda in forum Windows Software
    Replies: 5
    Last Post: 06-04-2011, 08:43 PM
  5. What is Workbook and Worksheets in Excel
    By Xylina in forum Windows Software
    Replies: 3
    Last Post: 06-06-2009, 07:13 PM

Tags for this Thread

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
  •  
Page generated in 1,710,813,752.17702 seconds with 16 queries