Password protection
`..¸.-X`"0MAK0"`X-.¸..´
I wonder what will be the best way to protect an excel file.?
I have vested so much time, using API, get the volume number, machine number
and user name, then I created a password, in dialogBox. For some normal user
it is difficult enough. But as far as I know it is not enough, I can crack
it myself, and I wonder should I convert it as (*.xla )file , I been told
that this add-in could be cracked too.
So, any of the Guru in this news can advice me with the best protected way
so if I give my file away I feel that it will not be cracked? Please post an
answer, or recommendation.
Appreciate any help in this matter.
--
`·.¸.-*`"0MAK0"`*-.¸.·´
``o000o^\/^o000o``
_ VB6- CAD2002 _
John Walkenbach
want to crack passwords (i.e., the vast majority of users).
But if someone really wants to break into your Excel file, they will find a
way. There is no method that is 100% effective. If you need to protect only
your macros, consider writing a COM add-in.
John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss
"`..¸.-X`"0MAK0"`X-.¸..´" <makde...@hotmail.com> wrote in message
news:-GWdnaqK96x...@comcast.com...
`..¸.-X`"0MAK0"`X-.¸..´
Appreciated, this was a quick advice,
My problem is I want to protect my modules -userForm- and one sheet which
contained my macros, and code? and the market now full with software which
easy cracked everything such as Advance products.
So it seam *.xla will not work, would you direct me of a link which more
explanatory for creating Com Add-in,
Thanks
MAK
"John Walkenbach" <jo...@j-walk.com> wrote in message
news:#Z65qkOiCHA.2664@tkmsftngp11...
John Walkenbach
http://support.microsoft.com/default.aspx
Search for "excel com add-in"
-John
"`..¸.-X`"0MAK0"`X-.¸..´" <`•.¸.-@`"0MAK0"`@-.¸.•´> wrote in message
news:IYqcnZy23ph...@comcast.com...
Mark Philpot
In the Workbook, goto File > Properties. Fill in all the
relevant details then, to protect your codes, go into VB
Editor click Tools> VBAProject Properties or Your "Project
Name" Properties. Click Protection Tab. Checkmark "Lock
For Viewing" then put in a Password. If you mistype or
forget your password, you are ****ed!
Tim Zych
> forget your password, you are ****ed!
Well, not exactly..there are utilities that can help you recover the ****.
--
Tim Zych
"Mark Philpot" <excelm...@yahoo.com.au> wrote in message
news:357701c28920$485a4730$3aef2ecf@TKMSFTNGXA09...
`..¸.-X`"0MAK0"`X-.¸..´
appreciated, my problem is more than that, my code will do this and save and
protect my file upon close so if you hit cancel, or the X for the dialog box
, it will close the dialogBox and protect the workBook. My problem is those
who invented utilities which can open the pass word even for your Module. I
cracked mine several time different utility.
Thanks for your reply any how.
MAK
"Mark Philpot" <excelm...@yahoo.com.au> wrote in message
news:357701c28920$485a4730$3aef2ecf@TKMSFTNGXA09...
`..¸.-X`"0MAK0"`X-.¸..´
Thanks a lot for your help, I will start reading it right now. Would you
able to help If I stuck ?
____________________________
I will not accept Email or attachment
I will not take the risk of viruses.
____________________________
`ท.ธ.-*`"0MAK0"`*-.ธ.ทด
``o000o^\/^o000o``
_ VB6- CAD2002 _
"John Walkenbach" <jo...@j-walk.com> wrote in message
news:eOIjBlPiCHA.1656@tkmsftngp11...
> Go here:
>
> http://support.microsoft.com/default.aspx
>
> Search for "excel com add-in"
>
> -John
>
> "`..ธ.-X`"0MAK0"`X-.ธ..ด" <`..ธ.-@`"0MAK0"`@-.ธ..ด> wrote in message
> > > "`..ธ.-X`"0MAK0"`X-.ธ..ด" <makde...@hotmail.com> wrote in message
> > > news:-GWdnaqK96x...@comcast.com...
> > > > Hello everyone...
> > > > I wonder what will be the best way to protect an excel file.?
> > > > I have vested so much time, using API, get the volume number,
machine
> > > number
> > > > and user name, then I created a password, in dialogBox. For some
> normal
> > > user
> > > > it is difficult enough. But as far as I know it is not enough, I can
> > crack
> > > > it myself, and I wonder should I convert it as (*.xla )file , I been
> > told
> > > > that this add-in could be cracked too.
> > > >
> > > > So, any of the Guru in this news can advice me with the best
protected
> > way
> > > > so if I give my file away I feel that it will not be cracked? Please
> > post
> > > an
> > > > answer, or recommendation.
> > > > Appreciate any help in this matter.
> > > >
> > > > --
> > > > `ท.ธ.-*`"0MAK0"`*-.ธ.ทด
`..¸.-X`"0MAK0"`X-.¸..´
using VB6, I get compile error : "object does not source automation events"
at this line
Dim WithEvents MyButton As Office.CommandBarButton
I will post it in the VB- NG in case you are not using VB.
Thanks again for your help.
MAK
"`..ธ.-X`"0MAK0"`X-.ธ..ด" <`..ธ.-@`"0MAK0"`@-.ธ..ด> wrote in message
news:yRmdnaalNOP...@comcast.com...
Mark Philpot
workbook, use a macro in each sheet code to protect it but
in the end, is your code that super fantastic and the
results so fantastic that nothing else will compare?
If, by chance, your code contains a virus macro that
affects the users' computer or other files, I would want
to protect against that. You could be in deep poo-poo if
you distributed a macro that was improper.
I have just started using the Userform password to stop
busybodies from looking at my spaghetti code. My macros
work okay but my code leaves a lot to be desired.
If somebody wanted to see my code, they need but ask for
the password.
No offence intended
`..¸.-X`"0MAK0"`X-.¸..´
My worBook is an estimate tool which I stated 1989 when I used Quarto Pro,
then converted step by step to an excel. It has a userform, this what I
refer to as a dialogBox, for user to log in with a proper pass word. the
password is unique for each machine because I collect the information throu
API, serial number of the machine"computer", username, VolumeNumber, then in
myCode I assign it my way.
So,If the user open the excel, the user form displayed, two choice either
cancel or add the correct password, if correct password it will unprotect
all the sheets for estimates with the exception of my code. If not, you have
to try again until you get the correct password or cancel. if you use the
cancel Button, it will shut down the estimate file no chance.
But with the new utilities I used two for testing I break through each sheet
and module and userform.
Have a good Day
"Mark Philpot" <excelm...@au.yahoo.com> wrote in message
news:cdcf01c289ea$d146b5e0$37ef2ecf@TKMSFTNGXA13...
`..¸.-X`"0MAK0"`X-.¸..´
Okay, I used the VB6, and the designer, and I created MyAddin.dll, and when
I start excel it works. what is the second step from here on?
any help will be appreciated.
MAK
"`..ธ.-X`"0MAK0"`X-.ธ..ด" <`..ธ.-@`"0MAK0"`@-.ธ..ด> wrote in message
news:j0OdnbzLsNv...@comcast.com...
`..¸.-X`"0MAK0"`X-.¸..´
Disregard, I found my way thanks and have a mice weekend
"`..ธ.-X`"0MAK0"`X-.ธ..ด" <`..ธ.-@`"0MAK0"`@-.ธ..ด> wrote in message