Protecting sheet but allowing pictures?!?

J

jontait

I've created a workbook with lots of hidden IF's etc and contro
buttons, therefore I've protected the workbook and each individua
sheet.

However, I'd like the user to be able to insert a picture into just on
of the sheets, when their cursor is in a particular cell. But when th
sheets are protected it greys out the ability to insert pictures.

Is there any way I can protect the sheet/workbook but tell excel t
allow this one function?

I'm not that good at VB coding so please be as descriptive a
possible.

Many, many thanks in anticipation of your repl
 
C

Craig

jontait said:
I've created a workbook with lots of hidden IF's etc and control
buttons, therefore I've protected the workbook and each individual
sheet.

However, I'd like the user to be able to insert a picture into just one
of the sheets, when their cursor is in a particular cell. But when the
sheets are protected it greys out the ability to insert pictures.

Is there any way I can protect the sheet/workbook but tell excel to
allow this one function?

I'm not that good at VB coding so please be as descriptive as
possible.

Many, many thanks in anticipation of your reply
Click to expand...


No VB Code needed here. When you protect your worksheet select the
option to allow users to Edit Objects. To insert the picture, select
Insert Object... Create from File. Browse for the picture needed.

I do not remember if Excel 97 has the same option to Edit Objects.

Craig
California, USA
 
J

jontait

Hi Craig

Thanks for your help, it works fine, however it allows the users t
alter the control buttons I've got on there.

Is there anyway in which I can tell it to allow objects but not contro
buttons, or can you think of any other way in which this can b
acheived?

Thanks
Jo
 
J

jontait

Craig

I'd like the picture to be displayed within the spreadsheet too, I'
not that familiar with objects but when I've been trying them out thi
morning I've noticed that they just show a link to the source file
Please see attached a picture of what I'm after.

Thank
 
J

jontait

Craig

I'd like the picture to be displayed within the spreadsheet too, I'
not that familiar with objects but when I've been trying them out thi
morning I've noticed that they just show a link to the source file
Please see attached a picture of what I'm after.

Thank

Attachment filename: image1.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=51645
 
Top