combo box problem
combo box problem
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: combo box problem

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have created a combo box, and through
    properties, I have selected the list range
    and those appear in the list, but when I protect the worksheet, the combo box does
    not drop down and allow me to choose. To do
    so I must unprotect the worksheet, highlight the combo box, right click, and selct object
    edit. Help?

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi cpc


    So long as its "Locked" property is set to False, protecting the sheet should have no effect. Unless you are using a Locked cell for its CellLink Property! If so this cell needs to be unlocked via the Format Cells dialog.



User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com