VBA SendKeys

[GRCArizona]

Hi - anyone know how to check if a user has the Developer Ribbon menu visible?

I've got the following code:

Worksheet_Activate
Application.SendKeys "%L%"
End Sub

This works fine (IE: selects the Developer tab when the sheet is activated), but if one of the users does not have the Developer tab installed, when worksheet is selected, all of the shortcut keys are displayed. The macro looks like it is basically hitting "ALT" to display the shortcut keys and not finding the Developer tab, so it is not hitting "ALT" to hide the shortcut keys.

so....million dollar question. In VBA, how can I have a line of code that does something like:
IF macro can select Developer ribbon tab then
msgbox "OK"
Else
msgbox "You don't have the Developer tab installed"
end if

 

[RickXL]

Hi,

This will show the Developer tab on start up:

Private Sub Workbook_Open()
    Application.ShowDevTools = True
End Sub

You could use the command elsewhere as well, of course.

 

[GRCArizona]

Rick...many thanks man! That works perfect. I've altered my code so it is now:

If Application.ShowDevTools = True Then
Msgbox "Developer Ribbon tab installed"
Else
Msgobx "Deverloper Ribbon tab hidden"
End If

works exactly for what I need.

 

[RickXL]

Good news and thanks for letting me know.

By the way, what exactly is a Deverloper?