+ Reply to Thread
Results 1 to 2 of 2

Using ComboBox on protected worksheet

  1. #1
    Forum Contributor
    Join Date
    02-16-2016
    Location
    england
    MS-Off Ver
    11
    Posts
    115

    Using ComboBox on protected worksheet

    Morning all,

    I have a combobox with a drop down list and want to protect the workbook, when the workbook is protected I cant use the comboBox.

    I have looked at unlocking it but cant seem to get it to work.

    Any ideas?

    D

  2. #2
    Forum Contributor
    Join Date
    02-16-2016
    Location
    england
    MS-Off Ver
    11
    Posts
    115

    Re: Using ComboBox on protected worksheet

    Hi,

    I figured it out, i unlocked the cell linked to the combo box.

    D

+ 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. Allow searchable combobox to be used in protected worksheet
    By PaulM100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2018, 04:40 AM
  2. Replies: 3
    Last Post: 03-22-2018, 11:25 AM
  3. Populating Combobox based on Combobox selection from EXCEL worksheet
    By JChaney17 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-04-2014, 08:14 AM
  4. Replies: 7
    Last Post: 08-06-2013, 02:23 PM
  5. Copy and paste insert rows with protected cells in protected worksheet
    By excel_gecko in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2012, 05:50 PM
  6. Changing value of a combobox on a protected worksheet
    By Matt_ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-07-2012, 11:40 PM
  7. [SOLVED] How do I unlock a protected worksheet:password protected
    By Terry Swift in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2005, 09:05 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