route217
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
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
Which Macro, there are 3 in the original post?
ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",t rue)"
Put the above code at the end of your code to re-show the ribbon
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
ASKER
hi experts (Shanan212)
you mean in the second part of the vba???
you mean in the second part of the vba???
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.