Security of a VBA Through a Pendrive

Maybe you could make an application that searches for the answer.

Developing Office Applications Using VBA - MSDN - Microsoft

Excel VBA Application Object - Easy

Excel MacrosExcel Application Events And VBA - Pearson, Chip

Can you just password protect the program instead?

And what process would make the Pendrive non-copyable? S.M.

Exactly my question. GA.

What you want is a USB Dongle, which is a hardware rather than software solution in a USB stick format. This is much harder to copy unlike a file on a memory stick.

Dongle.

Using the existing Excel protection and password settings is much easier and cheaper but a Dongle has enhanced security against copying.

What are you trying to protect and is it valuable enough to warrant the extra expense of a Dongle?

Many high end software packages have Dongle protection but they can justify the expense.

If it were me I would use the existing software password protection and just change the password for each and every different spreadsheet I sell. About the best protection you can get without going overboard and spending hundreds or thousands on Dongle hardware that could never be justified when weighed against potential losses due to piracy.

GA

Give it up. The best you can do with a human readable application like a VBA script is to encrypt the pendrive. Or, you could put the spreadsheet into Google drive read only and distribute the link.

'Cloud' access for copyright security purposes, hadn't thought of that.

Hi!
Your worry seems to be restricting unauthorised copy of your Excel workbook getting circulated.

You can not prevent getting the workbook copied.But you can prevent use of the unauthorised copy by adopting clever checks.

Your VBA project in the workbook open module can have a procedure to gather details of environment of the computer on which the Excel workbook resides. When the details do not match with the authorised parameters, the entire workbook can be deleted by the "KILL" command from within the module.

The unauthorised user may not understand what is happening and he may stop trying to get pirated copy.

However, your VBA project password may not be strong enough and if it is cracked and the code is read, this trick does not work.

Mahess