Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert Photo into a protected worksheet
How can I allow a user to insert a photo into a particular cell of a
protected worksheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert Photo into a protected worksheet
gnolla, how about with a macro?
The first one you can hard code the pic you want, the second one will bring up the insert picture dialog box and let them pick the one they want Sub test() Const PW As String = "123" 'Change Password Here ActiveSheet.Unprotect Password:=PW Range("C4").Select ActiveSheet.Pictures.Insert( _ "C:\My Documents\My Pictures\TestPic").Select 'change pic location and name above ActiveSheet.Protect Password:=PW End Sub Sub test1() Const PW As String = "123" 'Change Password Here ActiveSheet.Unprotect Password:=PW Range("C4").Select Application.Dialogs(xlDialogInsertPicture).Show ActiveSheet.Protect Password:=PW End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "gnolla" wrote in message ... How can I allow a user to insert a photo into a particular cell of a protected worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
How can I insert a picture from file while worksheet is protected | Excel Discussion (Misc queries) | |||
Sorting on a protected worksheet | Excel Discussion (Misc queries) | |||
Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
Insert worksheet | Excel Worksheet Functions |