Hi,

If you have controls on a sheet, I can't imagine why a user would try to copy it to their hard drive. It would be the same if you
had a userform. I guess the thing you are trying to avoid at this point, since you have disabled the save capability, is users
dragging the sheets to a different workbook or copying the workbook. You could do 2 things that I believe would help: 1st, you could
hide the sheet tabs and protect the sheet (and the workbook). This will keep folks from dragging individual sheets away. Also, you
could add code that checks to see where it is saved, and if it is in a "C" drive, then kick up a messagebox warning the user what he
is missing. You could go further and make the code self destruct the copied file when it is opened, perhaps after the user checks
"OK" on the messagebox. That should do it. Of course, a determined user who knows VBA well and also knows how to hack past the poor
password security in Excel will always be able to defeat your efforts. Additionally, a smart user could turn off macros before
opening, then open the VBA editor and delete the self destruct (and any other) code he/she wants to. I would suggest adding another
password to the VBA project, just to make things a little more of a hassle to tinker with.

HTH
--
RMC,CPA


"Brian C" wrote in message ...
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