Link to home
Start Free TrialLog in
Avatar of route217
route217Flag for United Kingdom of Great Britain and Northern Ireland

asked on

developer tab greyed out as a result of running macro below

Hi Experts

my developer tab in 2007 is greyed out as a result of the following macro, how do I restored it back to normal...along with page layout..

the code is on this question first vba code. .. https://www.experts-exchange.com/questions/28174942/One-macro-is-prevent-another-from-running.html
Avatar of ChloesDad
ChloesDad
Flag of United Kingdom of Great Britain and Northern Ireland image

Which Macro, there are 3 in the original post?
ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",true)"

Put the above code at the end of your code to re-show the ribbon
I would recommend this block

    With Application
        .ScreenUpdating = true
        .ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",true)"
        .DisplayFormulaBar = true
        .DisplayStatusBar = true
    End With

Open in new window

Avatar of route217

ASKER

hi experts (Shanan212)

you mean in the second part of the vba???
ASKER CERTIFIED SOLUTION
Avatar of Shanan212
Shanan212
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial