have finished my project on the Excel vba and I want to protect it by working only on one PC. is it possible?
http://www.mrexcel.com/forum/showthread.php?t=310332
have finished my project on the Excel vba and I want to protect it by working only on one PC. is it possible?
http://www.mrexcel.com/forum/showthread.php?t=310332
You could check the computer name (Environ("Computername") and password protect the poject, but not much more than that.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
And even then, the security on a VBA project password is extremely weak, and a motivated user will have ready access to cheap tools that will shred it in seconds.
If it's that important to you, then you need to be thinking about compiling an executable using tools like Visual Studio or this: http://www.calc4web.com/
Regards,
Patrick
I wept for myself because I had no PivotTable.
Then I met a man who had no AutoFilter.
Microsoft MVP for Excel, 2007 & 2008
Hi Nader,
Where is your cross-post link on MrExcel? I don't believe they look upon it any more kindly there. You should really give time for one site to respond before cross posting at another.
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
So much for all of thos 'heartfelt' apologies Thursday, and the promises to be more responsible in future.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
How time I have to wait,and isn't the way that post here right.( cross-post).Originally Posted by mdmackillop
You don't wait even one millisecond, when you make the second post you tell us, and then you go update the post elsehwere and tell them. That way, I for one can ignore your post, which I will do as a default position from now on.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Nader
If you've not read this, please do so.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
I did a croos-psot in this link:
http://www.vbaexpress.com/forum/show...t=18411&page=2
and I inserted the link in which I palce the croos-psot. and I didn't get a objection from you. Where .Aussiebear agree about that.
Dir you read this paragraph?If your requirements are urgent, then free forums are not the place for your questions. Consider a paid consultant in this instance.Find one forum and stick with it, preferably a very busy one so you reach a bigger audience. If you don't get a satisfactory answer in a reasonable amount of time (days, not hours), then:
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Nader, Yes you are following my request to the letter, but as the fellow members are suggesting to you, cross posting as soon as you are putting a question to the forum is not being very respectful. I admit I left that bit out, because I thought you would show some respect to the members here.
Consider this, if I came to you to learn the classical guitar and as soon as I asked you a question, I turned to the next instructor and asked him/her the same question, would you feel offended? Would you not think that I should at least listen to your responce, even try your method, before I jumped ship?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link