HOW DO I HIDE A MACRO EVENT FROM DISPLAYING WHEN RUNNING IN EXCE

---If you mean hide the code from user (while debug) you can password protect
VBA from menu in VBE ...ToolsProject PropertiesProtection tab.

---If you mean to hide what is happening while your code executes.
Application.Screenupdating = False
'your code
Application.Screenupdating = True

If this post helps click Yes
---------------
Jacob Skaria


"BEN" wrote:

HOW DO I HIDE A MACRO EVENT FROM DISPLAYING WHEN RUNNING IN EXCE

SHOUT real loud does it every time. Please do NOT type in all caps. Hard to
read and RUDE!!!
Try using

application.screenupdating=false
code
application.screenupdating=true

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BEN" wrote in message
...
HOW DO I HIDE A MACRO EVENT FROM DISPLAYING WHEN RUNNING IN EXCE