View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Werner Rohrmoser Werner Rohrmoser is offline
external usenet poster
 
Posts: 88
Default worksheet codename direct use vs. use in a object variable

Peter,

I'm always looking for a short and direct solution, see Bob's
contribution.
(I couldn't believe that there is no direct way)
Disadvantage is that I could get an issues with the Trust Access VB
projects security setting.

Your solution works fine as well and avoids any trouble with the
security setting,
so I have the choice.

Best Regards
Werner