View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default insert images in a protected worksheet

You are right

In Excel 2007 you can do it but not in older versions

You can create a macro to do it if you want.

Unprotect the sheet
call a browse dialog
Insert
Protect

Is that a option for you ?



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
I can do it in excel 2007

I go test it in Excel 2003

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"kub" wrote in message ...
hi Ron de Bruin

it still doesn't work..
i can edit a picture.. but i can't insert a new one.
what am i doing wrong?

thanks. ;)

"Ron de Bruin" escreveu:

hi Kub

When you protect the worksheet
check "Edit Objects" in the list

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"kub" wrote in message ...
hello..
please help me..
How do i insert an image in a protected woksheet?

thanks