LinkBack URL
About LinkBacks
I think another pair of eyes can really help or a better approach.
thanks.
namedrangeattendace is D$13:$AB$59
this should toggle letters X , H, C and "" on the given range
Please Login or Register to view this content.
I think another pair of eyes can really help or a better approach.
thanks.
namedrangeattendace is D$13:$AB$59
this should toggle letters X , H, C and "" on the given range
Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
1. You are missing a parameter:
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
2. I'm assuming that this is meant to work on multiple sheets since it's in the ThisWorkBook module(??) However, the named range refers to a particular sheet: =Sheet?!$D$13:$AB$59
Please Login or Register to view this content.
Last edited by protonLeah; 03-09-2015 at 02:30 AM.
Ben Van Johnson
it should work on multiple.
here's the file it's an attendance sheet where the user double clicks the cell to toggle
X - whole day absent
H- half day absent
C cutting classes
Attendance.xlsm
Some slight mods:
Tested sat...Please Login or Register to view this content.
Last edited by protonLeah; 03-09-2015 at 03:48 AM.
Nice thanks.
I didn't think of that.
Regards,
Vlady
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks