hi

For number 1, this may help:


Code:
--------------------
Option Explicit
Sub Demo()
Dim assignmentNamerange1 As Range
Dim assignmentNamerange2 As Range
Dim nextCellassignmentname As Long
Set assignmentNamerange1 = Application.InputBox(Prompt:="Please select the cell in your GRADEBOOK with the FIRST Assignment Name.", Title:="Select Assignment Name Cell", Type:=8)
Set assignmentNamerange2 = Application.InputBox(Prompt:="Please select the cell in your GRADEBOOK with the SECOND Assignment Name.", Title:="Select Assignment Name Cell", Type:=8)
nextCellassignmentname = assignmentNamerange2.Row - assignmentNamerange1.Row
'example of moving a set destance...
msgbox assignmentNamerange1.Offset(nextCellassignmentname , 0).address
'your code...
Set assignmentNamerange1 = Nothing
Set assignmentNamerange2 = Nothing
End Sub
--------------------


For numbers 2 & 3, yes, this can be done (possibly using a "log file"
on a central drive) but depending on the inquisitiveness of users the
"protection" can be broken. If you upload a file with what you've got so
far, someone may be able to tidy it up for you.

hth
Rob


--
broro183

Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99490