![]() |
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 |
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 |
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 |
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 |
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 |
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