title: Row level security in Excel - what approach should I use:
body: <p>Morning folks,</p>
  
  <p>Over the last couple of days I have been trying to find a way of implementing "pseudo" row level security in Excel using VBA macros.
  What I require is to filter all of my Excel table based on the Windows user credentials. The problem is that I am not sure how to tackle this issue and this is the only idea I have so far:</p>
  
  <pre><code> 1.Derive the NT account and store it in namedrange
   2. Use autofilter based on NamedRange for each table in my spreadsheet
   3. Delete / Hide the unnecessary rows ?
  </code></pre>
  
  <p>Example: </p>
  
  <p><a href="https://i.stack.imgur.com/pLdze.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pLdze.png" alt="enter image description here"></a></p>
  
  <p>Perhaps, there are other ways which are more suitable for my scenario, however I havent been able to find them.
  If you could point me into the right direction, I would appreciate it.</p>
  
  <p>Thanks</p>