|
insert images in a protected worksheet
hello..
please help me.. How do i insert an image in a protected woksheet? thanks |
insert images in a protected worksheet
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 |
insert images in a protected worksheet
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 |
insert images in a protected worksheet
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 |
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 |
insert images in a protected worksheet
Try inserting it as an "Object", "from file", rather than as a
"Picture"......or, you could copy and paste it. Vaya con Dios, Chuck, CABGx3 "kub" wrote: 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 |
insert images in a protected worksheet
ohhh...
thank you i'll try it... "Ron de Bruin" escreveu: 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 |
insert images in a protected worksheet
If you need help let me know
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "kub" wrote in message ... ohhh... thank you i'll try it... "Ron de Bruin" escreveu: 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 |
insert images in a protected worksheet
"Ron de Bruin" wrote...
.... In Excel 2007 you can do it but not in older versions .... "Ron de Bruin" escreveu: When you protect the worksheet check "Edit Objects" in the list .... "kub" wrote... .... How do i insert an image in a protected woksheet? Meaning Excel 2007 lacks worksheet protection in the sense of preventing adding ADDITIONAL objects to a protected worksheet, at least image objects? Not good. That would mean someone could insert a new image and place it on top of any image that might already be there. The OP may prefer such functionality, but I'm thinking of others who might want to prevent obscuring existing images. |
insert images in a protected worksheet
"CLR" wrote...
Try inserting it as an "Object", "from file", rather than as a "Picture"......or, you could copy and paste it. .... In Excel 2003 the Insert Object menu entry isn't disabled when a protected worksheet is active, but Excel won't put an object into it. It'll let you go through the motions in the Object dialog, but when you click OK, it'll display an error dialog stating 'Cannont insert object'. |
insert images in a protected worksheet
Hi Harlan
Not good. That would mean someone could insert a new image and place it on top of any image that might already be there. The OP may prefer such functionality, but I'm thinking of others who might want to prevent obscuring existing images. I agree with you on this I go check if this is correct that it is working like this in 2007. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Harlan Grove" wrote in message ... "Ron de Bruin" wrote... ... In Excel 2007 you can do it but not in older versions ... "Ron de Bruin" escreveu: When you protect the worksheet check "Edit Objects" in the list ... "kub" wrote... ... How do i insert an image in a protected woksheet? Meaning Excel 2007 lacks worksheet protection in the sense of preventing adding ADDITIONAL objects to a protected worksheet, at least image objects? Not good. That would mean someone could insert a new image and place it on top of any image that might already be there. The OP may prefer such functionality, but I'm thinking of others who might want to prevent obscuring existing images. |
| All times are GMT +1. The time now is 03:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com