+ Reply to Thread
Results 1 to 3 of 3

how to protect figure,signature against deletion but other symbols not

  1. #1
    Forum Contributor
    Join Date
    12-25-2012
    Location
    gent,belgium
    MS-Off Ver
    Excel 2021
    Posts
    146

    how to protect figure,signature against deletion but other symbols not

    Hi
    On the photo you see a calendar.
    So the picture that are market with the arrows the user must can't delete it.
    But when a use select a date to take a day of of work. By a new created menu Verlof there can the user select the code from a dropdown for the day not at work.
    And than a macro draws a shape on the selected day a rectangle and a triangle.
    So i protect the sheet than i can't put the shapes on the calendar.
    So i did a other thest and mark edit objects that works fine. Now i can add and delete shapes in the callendar. But also the 3 pictures marked with the black arrows on the figure below and that is not the intention

    So i don't want to protect and unprotect the sheet by vba because they need my password.
    Is it not posible to select a range where object are not poretect to edit


    hb9hj1q2.jpg
    Last edited by glda19; 12-02-2018 at 11:03 AM.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: how to protect figure,signature against deletion but other symbols not

    Crossposted: https://www.helpmij.nl/forum/showthr...ligen-en-macro



  3. #3
    Forum Contributor
    Join Date
    12-25-2012
    Location
    gent,belgium
    MS-Off Ver
    Excel 2021
    Posts
    146

    Re: how to protect figure,signature against deletion but other symbols not

    it's not a cross post

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Protect text box from deletion but allow editing
    By Jerbinator in forum Excel General
    Replies: 0
    Last Post: 02-12-2016, 08:33 AM
  2. How to protect a mail from deletion
    By Elangovan89 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 05-15-2013, 04:10 PM
  3. How can I protect a WorkBook from Deletion
    By dsexpress in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2008, 07:43 AM
  4. protect sheets from deletion
    By stevekirk in forum Excel General
    Replies: 3
    Last Post: 01-05-2007, 03:18 AM
  5. Protect worksheet from deletion
    By Richard in forum Excel General
    Replies: 1
    Last Post: 07-17-2006, 10:45 AM
  6. Protect formulas but allow deletion of rows?
    By Hubitron2000 in forum Excel General
    Replies: 1
    Last Post: 03-21-2006, 07:35 PM
  7. protect a file from deletion
    By SheriTingle in forum Excel General
    Replies: 2
    Last Post: 01-04-2006, 09:40 PM

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