+ Reply to Thread
Results 1 to 3 of 3

How do I protect a Listbox control on a protected sheet from being cut/moved?

  1. #1
    Registered User
    Join Date
    03-26-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    10

    How do I protect a Listbox control on a protected sheet from being cut/moved?

    I'm using Excel 2016. I have a Listbox control on a protected work sheet. The cell that the control is in, is unprotected so a user can select from the list. The problem I have is that even though the sheet is protected a user can do a Ctrl + X or right click cut and move it to another cell. Thank you in advance...

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: How do I protect a Listbox control on a protected sheet from being cut/moved?

    Try this method. See attachment with example and instruction.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-26-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    10

    Re: How do I protect a Listbox control on a protected sheet from being cut/moved?

    BMV. thank you so very much for your time and example. I would never have thought of that method. I hide the second column to make it look like just one column and then I had two problems with it. First of all I wasn't able to use the delete key to remove an item from the list like you can in a single column list so I thought lets clear the contents with vba and that wouldn't work either as part for the merged cell was hidden. I'm currently working on another solution.

    It's a shame the Microsoft didn't provide an option to protect the object.

    Thank very much!

+ 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. [SOLVED] Find as you type in listbox control - solution for multi-column listbox - vba dictionary
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-05-2018, 03:42 AM
  2. [SOLVED] How to Protect/password selected value in ListBox (ActiveX Control)?
    By Imran Magsi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2017, 08:04 AM
  3. [SOLVED] Drop Down control fails when sheet is protected
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2016, 12:39 AM
  4. How to protect shapes from being inadvertently moved by user
    By faraoosiris in forum Excel General
    Replies: 2
    Last Post: 02-18-2014, 07:56 AM
  5. [SOLVED] To Run Macro in A Protected Sheet (Data in the Sheet will be Moved)
    By kittu55 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-24-2012, 10:51 PM
  6. Does Protect still occur if sheet is already protected?
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2010, 04:24 PM
  7. Replies: 2
    Last Post: 01-06-2005, 11:06 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