MACRO EVENT
 

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

MACRO EVENT
 

---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

MACRO EVENT
 

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