Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert pictures
I've protected my worksheet (an incident report form), but left some cells
unlocked so as the user can enter information. I can enter text, but cannot enter (insert) a picture from file (for incident photos). I can enter the photos when the whole sheet is unprotected, but that would leave other cells and information vunrable to being changed. signed, Overly Confused |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert pictures
Hi,
when you protect the sheet, check the Edit objects option in the dialog box. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "AZU" wrote: I've protected my worksheet (an incident report form), but left some cells unlocked so as the user can enter information. I can enter text, but cannot enter (insert) a picture from file (for incident photos). I can enter the photos when the whole sheet is unprotected, but that would leave other cells and information vunrable to being changed. signed, Overly Confused |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert pictures
No, sorry it never worked. I click on "Insert"-Picture- (but everything
here is grayed out). I'll keep trying other options, but I'm running out of ideas. "Shane Devenshire" wrote: Hi, when you protect the sheet, check the Edit objects option in the dialog box. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "AZU" wrote: I've protected my worksheet (an incident report form), but left some cells unlocked so as the user can enter information. I can enter text, but cannot enter (insert) a picture from file (for incident photos). I can enter the photos when the whole sheet is unprotected, but that would leave other cells and information vunrable to being changed. signed, Overly Confused |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert pictures
1. You can't insert a picture into a cell so it doesn't matter if cells are
locked or unlocked. 2. You will have to use a macro that unprotects, inserts the picture then re-protects. Something like this................. Sub insert_pic() ActiveSheet.Unprotect filetoopen = Application _ .GetOpenFilename("pictures (*.jpg), *.jpg") 'browse to a folder and double-click on desired *.jpg If filetoopen < False Then ActiveSheet.Pictures.Insert (filetoopen) End If ActiveSheet.Protect DrawingObjects:=False 'DrawingObjects:=False allows editing the inserted picture End Sub Gord Dibben MS Excel MVP On Thu, 5 Mar 2009 15:13:02 -0800, AZU wrote: I've protected my worksheet (an incident report form), but left some cells unlocked so as the user can enter information. I can enter text, but cannot enter (insert) a picture from file (for incident photos). I can enter the photos when the whole sheet is unprotected, but that would leave other cells and information vunrable to being changed. signed, Overly Confused |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert pictures
If you want a password on the protection use these lines instead.
Sub insert_pic() ActiveSheet.Unprotect Password:="justme" rest of code<<<< ActiveSheet.Protect Password:="justme", DrawingObjects:=False End Sub Then you could lock the project from viewing to prevent snoopers from seeing the code and the sheet protection password. Alt F11 to open VBE Right-click on your project ans select VBAProject PropertiesProtection Selected locked for viewing and enter a password. Save the file to enable the locking. Gord On Thu, 05 Mar 2009 17:10:19 -0800, Gord Dibben <gorddibbATshawDOTca wrote: 1. You can't insert a picture into a cell so it doesn't matter if cells are locked or unlocked. 2. You will have to use a macro that unprotects, inserts the picture then re-protects. Something like this................. Sub insert_pic() ActiveSheet.Unprotect filetoopen = Application _ .GetOpenFilename("pictures (*.jpg), *.jpg") 'browse to a folder and double-click on desired *.jpg If filetoopen < False Then ActiveSheet.Pictures.Insert (filetoopen) End If ActiveSheet.Protect DrawingObjects:=False 'DrawingObjects:=False allows editing the inserted picture End Sub Gord Dibben MS Excel MVP On Thu, 5 Mar 2009 15:13:02 -0800, AZU wrote: I've protected my worksheet (an incident report form), but left some cells unlocked so as the user can enter information. I can enter text, but cannot enter (insert) a picture from file (for incident photos). I can enter the photos when the whole sheet is unprotected, but that would leave other cells and information vunrable to being changed. signed, Overly Confused |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert pictures
Thanks, I'll try that. I'm not good at VB, but I'll try and muddle through
it. Trial & Error..... "Gord Dibben" wrote: If you want a password on the protection use these lines instead. Sub insert_pic() ActiveSheet.Unprotect Password:="justme" rest of code<<<< ActiveSheet.Protect Password:="justme", DrawingObjects:=False End Sub Then you could lock the project from viewing to prevent snoopers from seeing the code and the sheet protection password. Alt F11 to open VBE Right-click on your project ans select VBAProject PropertiesProtection Selected locked for viewing and enter a password. Save the file to enable the locking. Gord On Thu, 05 Mar 2009 17:10:19 -0800, Gord Dibben <gorddibbATshawDOTca wrote: 1. You can't insert a picture into a cell so it doesn't matter if cells are locked or unlocked. 2. You will have to use a macro that unprotects, inserts the picture then re-protects. Something like this................. Sub insert_pic() ActiveSheet.Unprotect filetoopen = Application _ .GetOpenFilename("pictures (*.jpg), *.jpg") 'browse to a folder and double-click on desired *.jpg If filetoopen < False Then ActiveSheet.Pictures.Insert (filetoopen) End If ActiveSheet.Protect DrawingObjects:=False 'DrawingObjects:=False allows editing the inserted picture End Sub Gord Dibben MS Excel MVP On Thu, 5 Mar 2009 15:13:02 -0800, AZU wrote: I've protected my worksheet (an incident report form), but left some cells unlocked so as the user can enter information. I can enter text, but cannot enter (insert) a picture from file (for incident photos). I can enter the photos when the whole sheet is unprotected, but that would leave other cells and information vunrable to being changed. signed, Overly Confused |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't insert pictures | New Users to Excel | |||
Need Help with auto insert of pictures | New Users to Excel | |||
How do I insert pictures in excel with the correct aspect ratio? | Excel Discussion (Misc queries) | |||
Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
can't insert, delete or move pictures | Excel Discussion (Misc queries) |