Thread: find out if a sheet is open by another user
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default find out if a sheet is open by another user
See the UserStatus Property in VBA Help
--
Gary''s Student - gsnu200790


"Dan" wrote:

Is there a way to find out in VBA if an xls is open in read/write mode by
someone and who that someone is.
Many thanks,
Dan
Reply With QuoteReply With Quote