View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Testing for Shared Workbook

I need to check to see if a workbook that resides on a networked drive has
been set to "shared" mode (Tools, Share Workbook...). Is that possible,
using VBA? If so, can someone please direct me to where I can find some
sample code? (I'm a VBA novice.) Thanks in advance for any help.
Bob