+ Reply to Thread
Results 1 to 9 of 9

Pictures can not be deleted or changed with sheet protected

  1. #1
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Exclamation Pictures can not be deleted or changed with sheet protected

    Hi,
    I am using following code to insert a picture in a cell.
    With this I click on the cell that I want the picture, then press commandbutton to select picture and insert.

    Things are fine so long sheet is unprotected.
    But when it is protected, I cant delete the inserted picture or delete it to change it .
    I have modified code but it does not work.
    Any help please.
    Regards

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: Pictures can not be deleted or changed with sheet protected

    Apology.
    Last line in second code is :
    Sheets("WC").Protect "abcd"
    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Pictures can not be deleted or changed with sheet protected

    You can protect sheets but leave pictures and objects editable

    Please Login or Register  to view this content.
    Elegant Simplicity............. Not Always

  4. #4
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: Pictures can not be deleted or changed with sheet protected

    Hi,
    Thanks mate.
    Where to insert this line?
    I tried to modify and it does not accept it.
    Regards

  5. #5
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Pictures can not be deleted or changed with sheet protected

    Replace the line
    Sheets("WC").Protect "abcd"
    with
    Sheets("WC").Protect DrawingObjects:=False, Contents:=True, Scenarios:=True, AllowDeletingRows:=True Password:="abcd"

  6. #6
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: Pictures can not be deleted or changed with sheet protected

    Hi,
    Sorry mate.
    It is still not bee accepted. It is highlighted in red.
    Something is missing
    Apology
    Regards

  7. #7
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Pictures can not be deleted or changed with sheet protected

    My mistake

    Sheets("WC").Protect DrawingObjects:=False, Contents:=True, Scenarios:=True, AllowDeletingRows:=True, Password:="abcd"

  8. #8
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: Pictures can not be deleted or changed with sheet protected

    Hi Mate,
    It works very well indeed.
    Thanks a millions. Thanks for a prompt help.
    Hope one day I can also help others as you all do!
    Regards

  9. #9
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Pictures can not be deleted or changed with sheet protected

    Glad to help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1