ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to hide something with excel (https://www.excelbanter.com/excel-programming/340362-how-hide-something-excel.html)

[email protected]

how to hide something with excel
 
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


dominicb[_130_]

how to hide something with excel
 

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


Mike Fogleman

how to hide something with excel
 
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




sajay

how to hide something with excel
 
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


sajay

how to hide something with excel
 
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

how to hide something with excel
 
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


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com