Thread: how can I add a picture into protected worksheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hernandez, Roberto
 
Posts: n/a
Default how can I add a picture into protected worksheet?
Hi Chusena,
Unprotect sheet, insert picture, protect sheet

Sheets("YourSheet").Unprotect "Password"
'... your code for inserting pics
Sheets("YourSheet").Protect "Password"

Kind Regards.
"Chusena" escribió en el mensaje
...
I am creating an exel template which I had protected. However, I need to
insert images/pictures but I am not able to do so although the particular
cell is not protected. Is there a way to do this? I have Office 2002.


Reply With QuoteReply With Quote