[NLRS] RoverMania VI on the Web - spreadsheet error

[John P. Toscano]

John (JK) Kalenowsky, K9JK wrote:
> Paul and others,
> 
> I have "my" Excel set to 'prompt' me about allowing Macros to run.
> 
> When I selected "Disable Macros" I received the results that Paul 
> described after changing "My Grid".
> 
> When I selected "Enable Macros", I could change "My Grid" and the 
> "Bearing" and "Km" DID change and update.
> 
> So...a 'solution' appears to be to "Enable Macros". Perhaps JT can 
> confirm that Macros "need" to be enabled.

Yes, John. Thanks for getting the word out more promptly than I was able 
to reply to Paul's query. You have the exact solution needed.  I guess I 
was a little bit too vague on the web page, when I said...

           This spreadsheet uses VBA (Visual Basic for Applications)
           code to speed up the computation of bearing and distance
           information while keeping the file compact. Unfortunately,
           depending on how your Security settings are set in Excel,
           the VBA code may be stripped out without warning, or you
           may be given a dire warning about the possibility of the
           file containing dangerous macros or other malware
           (malicious software), and asking you if you really want
           to proceed to enable macros. There is nothing dangerous
           lurking in this file, so it is safe to "enable macros".
           If you don't (or if you are not given the option), none of
           the bearing or distance calculations will be correct.

Good luck to all this weekend. :)
WØJT