MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

VBA to use unique password using volume serial number

  Asked By: Nisha    Date: Mar 23    Category: MS Office    Views: 3596

I am a newbie to VBA (been playing with Excel and Macro recorder for

Trying to release a workbook for free, but don't want people making
money out of it, so need some sort of control.

I would like to have users of a spreadsheet have to enter their
Volume Serial Number as a password to allow access to the workbook.

I would only like to have the user to do it once on that machine and
then check each time it is opened that it is still on the same hard
drive it was copied to (i understand the issue that VSN can be
changed with a format)

Is there any code out there that can do this? or point me in the
right direction please

and if so, I think I would need a little explanantion on how to use



2 Answers Found

Answer #1    Answered By: Randy Warren     Answered On: Mar 23

seems your proposal to protect the excel  files will be
useless....since it is obvious that macro  (vba excel) is kinda open
source file....

if you can protect to open the file, but after the user  open the file,
they can see and copy your listing program....

i don't want to discourage, but in my experience we can't protect the
listing program in excel perfectly.... if other have any opinion feel
free to correct me

Didn't find what you were looking for? Find more on VBA to use unique password using volume serial number Or get search suggestion and latest updates.