I have created a spreadsheet (Excel 2000) that allows for user input (with
drop downs and option buttons).

My concern is that a user could save this sheet to their desktop, rather
than downloading the sheet from a centralized Lotus Notes database. If the
user does this, they won't have the most current version of the sheet.

Would a userform provide the capability to stop a user from saving the sheet
and missing out on updates? NOTE in the spreadsheet, I have already disabled
the Save and Save As functions with VBA code, but if they don't enable the
Macros they can still save it to their C drive.

I also played with the idea of saving it as an Add-In, but the spreadsheet
didn't transfer over correctly.

I would appreciate any help in resolving these challenges.

Thanks,

Brian