title: Auto run good Macro before User Macro?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/125449/how-to-protect-cells-in-excel-but-allow-these-to-be-modified-by-vba-script">How to protect cells in Excel but allow these to be modified by VBA script</a>  </p>
  </blockquote>
  
  
  
  <p>any chance to run a specific marco [GodMarco] before any marco [UserMarco] which fired by user?</p>
  
  <p>CASE I</p>
  
  <p>I have a worksheet, which have lots button to do different action by user.</p>
  
  <p>I have normal cells to let user input data, and have hidden cells to do the dirty work.</p>
  
  <p>And since user may user [arrow] or [tab] to circle through, I have to protect the sheet.</p>
  
  <p>And made them not selectable.</p>
  
  <p>And now VBA stopped.</p>
  
  <p>I know I can add vba codes to unprotect and protect again and again, but I think it is stupid to add them to each marco.</p>
  
  <p>So can it be something like GODMODE that before each marco fired by user, run GODMARCO1, and after user marco, run GODMARCO2?</p>
  
  <p>[DONE, THANK YOU.] CASE II</p>
  
  <p>Or can we get some cells not selectable by user but selectable by VBA?</p>
  
  <p>THANK YOU VERY MUCH.</p>