ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Allow Insert of objects onto Protected Worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/96780-allow-insert-objects-onto-protected-worksheet.html)

ShaneBell

Allow Insert of objects onto Protected Worksheet
 

Is there a way to have protection enabled on selected cells while
allowing other users the flexibility to insert pictures or objects on a
worksheet?


--
ShaneBell
------------------------------------------------------------------------
ShaneBell's Profile: http://www.excelforum.com/member.php...o&userid=35865
View this thread: http://www.excelforum.com/showthread...hreadid=556871


CLR

Allow Insert of objects onto Protected Worksheet
 
Uncheck the "OBJECTS" box while doing the ProtectSheet procedure.....

hth
Vaya con Dios,
Chuck, CABGx3



"ShaneBell" wrote:


Is there a way to have protection enabled on selected cells while
allowing other users the flexibility to insert pictures or objects on a
worksheet?


--
ShaneBell
------------------------------------------------------------------------
ShaneBell's Profile: http://www.excelforum.com/member.php...o&userid=35865
View this thread: http://www.excelforum.com/showthread...hreadid=556871




All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com