LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default Shared Workbook

In a shared work, I would like a user to be able to double-click on a
cell in a particular column, and if the cell is blank, the user's
username is entered. But if the cell has had something entered in it
by another user, the program will detect that and offset to a cell
below the selected one.

I am getting close to what I want with the following but it is not
working perfectly.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
ActiveWorkbook.Save
If Target.Column = 3 Then
If Selection.Value = "" Then
Selection.Value = Environ("username")
Else
Selection.Offset(1, 0).Select
ActiveCell.Value = Environ("username")
End If
End If
ActiveWorkbook.Save
End Sub

The first workbook save should make other users' entries show up on
the current screen but this has not been preventing overwriting. Also,
it will probably be necessary to skip more than one line with entries
sometimes so I think it needs a loop of some kind. Further, it appears
that cutcopy mode stays on when selection is an empty cell, but turns
off when selection is a cell with something in it. Any help would be
appreciated.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
shared workbook is set up is not 'shared' on network moviemaker novice Excel Worksheet Functions 0 April 7th 10 03:31 AM
shared workbook - shared workbook options grayed out Edward Letendre Excel Discussion (Misc queries) 0 March 3rd 10 10:47 PM
Shared Workbook - Slow opening of shared workbook. [email protected] Excel Programming 2 August 29th 07 05:14 PM
Printing viewing a shared workbook on a shared drive aloomba Excel Discussion (Misc queries) 0 April 13th 07 02:52 PM
update pivot in shared shared workbook 00George00 Excel Discussion (Misc queries) 1 August 23rd 06 08:16 PM


All times are GMT +1. The time now is 09:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"