<div>
Which Macro, there are 3 in the original post?
</div>


<div>
ExecuteExcel4Macro &quot;SHOW.TOOLBAR(&quot;&quot;Ribbon&quot;&quot;,t<wbr />rue)&quot;<br />
<br />
Put the above code at the end of your code to re-show the ribbon
</div>


<div>
I would recommend this block<br />
<br />

<pre><code id="code-20-39298073-1">    With Application
        .ScreenUpdating = true
        .ExecuteExcel4Macro &quot;SHOW.TOOLBAR(&quot;&quot;Ribbon&quot;&quot;,true)&quot;
        .DisplayFormulaBar = true
        .DisplayStatusBar = true
    End With</code></pre>
</div>


<div>
hi experts (Shanan212)<br />
<br />
you mean in the second part of the vba???
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
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..<br />
<br />
the code is on this question first vba code. .. <a href="https://www.experts-exchange.com/questions/28174942/One-macro-is-prevent-another-from-running.html" rel="ugc">https://www.experts-exchange.com/questions/28174942/One-macro-is-prevent-another-from-running.html</a>
</div>
</div>


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. .. http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28174942.html

Which Macro, there are 3 in the original post?

ExecuteExcel4Macro &quot;SHOW.TOOLBAR(&quot;&quot;Ribbon&quot;&quot;,true)&quot;

Put the above code at the end of your code to re-show the ribbon

hi experts (Shanan212)

you mean in the second part of the vba???

developer tab greyed out as a result of running macro below

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.