DEAR ALL
For my ship cargo loading, i have written various options and so many
sheets and links. Any new cargo officer gets puzzled and confused
where to go and what to click. In access the tool tip was great help.
For example, they have to methodically go step by step and i have
written it down. Still they miss out some steps and results are
disastrous. Short clue is - if u first dont update sheet1 then sheet
12 answers will b wrong and canot use it for stability and so on.

So pls advice me how to go about writing a detail help file to pop up
when they click f1 when they use my fuly automate excelsheet and also
is there anyway to halt them from going haphazardly -- like a
separate sub procedure to keep tracking by giving a reference number
and logging it in cells as a cross check and to continue if the
reference numbers tally. I even thought of a check list form with
option buttons so that for each operaion of command buttons they have
to first go and complete the said steps. Pls adv.