<div>
No worries &nbsp;- glad it helped
</div>


<div>
<div class="content wysiwyg-content">
Hello All,<br />
<br />
I am sending a protected workbook to &nbsp;folks. I was wondering is that any thing i can do to totally remove or hide the macro button under the developer tab....anything i can do to not let the user see or access it....coz i have several of them that could be seen if i go to Developer tab &gt;&nbsp;Macro<br />
i know that if i make a sub private it will not show up in that macro list...but to implement that change all across 100 of them - doesn't make sense in terms of how much time deadline at hand...
</div>
</div>


Hello All,

I am sending a protected workbook to  folks. I was wondering is that any thing i can do to totally remove or hide the macro button under the developer tab....anything i can do to not let the user see or access it....coz i have several of them that could be seen if i go to Developer tab > Macro
i know that if i make a sub private it will not show up in that macro list...but to implement that change all across 100 of them - doesn't make sense in terms of how much time deadline at hand...

Banish the Macro Button_Protection To THE Ultimate!

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.