PC Review


Reply
Thread Tools Rate Thread

how can I tell who has a workbook open

 
 
=?Utf-8?B?YnBvbGFuZDU4?=
Guest
Posts: n/a
 
      6th Sep 2007
How do I get to the area to record my name so if someone tries to open a
workbook I am in it will tell them who has it open?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?R2FyeScncyBTdHVkZW50?=
Guest
Posts: n/a
 
      6th Sep 2007
I answered this question poorly in :

http://groups.google.com/group/micro...rnum=17&hl=en#

Tom Ogilvy gave a much better suggestion in the same post. His approach
involves a small macro, which we can write if you like the approach.
--
Gary''s Student - gsnu200743


"bpoland58" wrote:

> How do I get to the area to record my name so if someone tries to open a
> workbook I am in it will tell them who has it open?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i open a data workbook when i open a timesheet workbook swain.s@blueyonder.co uk Microsoft Excel Misc 2 4th Jan 2009 04:50 PM
Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. amorrison2006@googlemail.com Microsoft Excel Programming 1 13th May 2007 01:46 PM
Workbook.Open doesn't leave an open Workbook Mac Lingo Microsoft Excel Programming 4 23rd Apr 2005 11:17 PM
How do you program so that Workbook B cannot be open unless Workbook A is open? Plus I need to validation Marcello do Guzman Microsoft Excel Programming 2 5th Dec 2004 06:50 AM
What commands do you use to name a workbook, save a workbook,open a workbook Steven R. Berke Microsoft Excel Programming 1 24th Jul 2003 11:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:09 AM.