Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password to Lock out VBA from View
Is it possible to create a Password to lock the VBA from view via
code? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password to Lock out VBA from View
Yes there is but it would be classed as "virus" activity if you use it to change someone elses settings. What you should do is password protect your project first before distributing it, this is then your choice and not manipulating the choices of others, i can see no valid reason to lock a vba project after it is distributed! -- The Code Cage Team Regards, The Code Cage Team ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=6604 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password to Lock out VBA from View
No valid reason? Here's one, I am distributing a file that I create
via code, part of this code disables thecopy/paste feature which is held within ThisWorkbook so that the content is not copied to another file, I also restrict users access to the said file. All these protections are not fool proof, but they work with the users I'm dealing with "What you should do is password protect your project first before distributing it" this is what I am attempting to do via code Is the reason good enough?? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password to Lock out VBA from View
Seanie
You need to use sendkeys and make sure access to VBA project is trusted hree is some more info: http://www.vbaexpress.com/forum/showthread.php?t=22421 Cheers Simon Blog: www.smurfonspreadsheets.net Seanie wrote: No valid reason? Here's one, I am distributing a file that I create via code, part of this code disables thecopy/paste feature which is held within ThisWorkbook so that the content is not copied to another file, I also restrict users access to the said file. All these protections are not fool proof, but they work with the users I'm dealing with "What you should do is password protect your project first before distributing it" this is what I am attempting to do via code Is the reason good enough?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stop view and lock columns | Excel Worksheet Functions | |||
Password protection in macro ( Anybody can view my password in VB | Excel Discussion (Misc queries) | |||
How to password / lock a folder instead of each files | Excel Discussion (Misc queries) | |||
Lock Screen to current view | Excel Programming | |||
How to lock the view of certain number of rows | Excel Programming |