hi friends,
this is about hiding something in excel

you can have codes but as comments
or can make sheets very hidden

but wait!! is there any more options there?/

I used to hide sheets and pwd the visual basic editor

yours
sajay

You still can. in VBE, select your project and in the Tools menu, VBAProject
Properties, then the Security tab, set password.

Mike F
wrote in message
oups.com...
hi friends,
this is about hiding something in excel

you can have codes but as comments
or can make sheets very hidden

but wait!! is there any more options there?/

I used to hide sheets and pwd the visual basic editor

yours
sajay

dear Mike,


that is the thing i do right now.
but many say it is not secured.
is there any other method??



yours
sajay

It secure from most prying eyes.

But if you really want security, you'll compile your code into a COM addin
(beyond me).

sajay wrote:

dear Mike,

that is the thing i do right now.
but many say it is not secured.
is there any other method??

yours
sajay

--

Dave Peterson

Good afternoon

'Fraid not. And if you want to hide something best not use Excel. I
is SO easy to unhide an xlveryhidden sheet using VBA, and most exper
users could remove the VBA password in less time than it took you t
apply it. You can set the hidden flag (ctrl + 1, protection) that wil
take effect when sheet protection is invoked, but that protection to
could be removed in under a minute - the password is irrelevant.

Any information contained in a spreadsheet can be laid bare withi
seconds, no matter how deeply it is buried. In fact this guy has lai
down a challenge for any one to send him a workbook containin
information that he can't access.

http://www.xl-logic.com/pages/challenge.html

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=46846

oh thanks very much dominic. it's really horrible that even microsoft
can't save itself.


I just wanted to add my signature page (hidden) so that when i get a
file to modify i can check what work it was and when i did it.


yours
sajay