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?
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.
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.
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.