Excel 2007 - VBA with Disabled Dropdown

[MJK]

Hi - I inherited an Excel VBA spreadsheet that has data validation dropdowns that are disabled (grayed out) in the menu. What type of code should I be looking for the enable the data validation dropdowns?
Thanks
MJK

 

[Datsmart]

Is there any Protection setup on the workbook or worksheet?

 

[MJK]

Yes the was protection. I unprotected the sheet and was able to edit other parts of the spreadsheet, but the data validation is still grayed out in the menu. I think there may be code that needs to be modified, but I have no clue what to look for.

 

[Datsmart]

Do you have any event procedures taking place?
Right Click the Sheet Tab, click View Code...
If the VBA editor page that opens is blank, you have no worksheet event code.
You can also check for WorkBook event code.
In the VBA editor, double-click the "Thisworkbook" module.
If the VBA editor page that opens is blank, you have no workbook event code.
To open the "Thisworkbook" module in version prior to Excel 2007;
Right Click the Excel Icon to the left of the File Menu, click View Code...

 

[MJK]

It there - so it appears that is not a dropdown (data Validation) but instead a list box - correct?

Private Sub ListBox1_Click()

End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim CommBarTmp, Commbar As CommandBar

If ScheduleToBeSet = True Then

For Each Commbar In Application.CommandBars

Set CommBarTmp = Commbar.FindControl(ID:=847, recursive:=True)

If Not CommBarTmp Is Nothing Then CommBarTmp.Enabled = False

Next

End If

End Sub

 

[Datsmart]

I would Delete/Remove the code you listed above.
It is making some kind of changes to your workbook menus.

After deleting the code, save the workbook with a different name and reopen.
It should be fine then.