shtPic.Unprotect sPassword
'code to insert pic
shtPic.Protect sPassword

Tim

"Sam Kuo" wrote in message
...
Hi Tim,

1) I've sorted out the error handling issue with non-picture file by
adding
FileFilter (which limits the acceptable file format to specified picture
files only) in the GetOpenFileName method you suggest. i.e.

v = Application.GetOpenFilename("Image Files (*.jpg; *.jpeg; *.bmp;
*.tiff;
*.tif),*.jpg; *.jpeg; *.bmp; *.tiff; *.tif)")

2) But the problems with protected worksheet still trouble me...I'll
probably open a new thread if I still cannot figure out how.

Many thanks for your assistance so far :-)

Sam