Hi,
Anyone can press Alt+F11 to go to visual basic editor but if the vba
project is password protected then they wld not be able to see the
code.
Your way is also good.
Best Regards,
DILIPandey
On 11/27/10, Rajesh K R wrote:
> Hi Dilip
> i tried your code its working well, but if anybody press
Hi Dilip
i tried your code its working well, but if anybody press ALT + F 8 any
body get some macro code is there i solved it in this way is there any
better way for this
Sub unhidesheet()
If Application.InputBox("ENTER PASSWORD") = "123" Then
Sheet1.Visible = xlSheetVisible
Else
Sheets("hide").Vis
Hi Rajesh,
You can use following code:-
Sheet1.Visible = xlSheetVeryHidden
Or
Sheets("Sales").Visible = xlSheetVeryHidden
Now, you can not see it using Format->Sheet-> unhide
To get it, use following code
Sheet1.Visible = True
Further to this, you can protect your VBA code as well, so that no
what i need is that i have many files in my computer each having a
many worksheets
among this many of the sheets contain datas which is not allowed
others to access
if i am simply hide a sheet or range they will understand that some
sheets or data is hided here .i want to over come this. normaly no
Hi Rajesh,
If you are talking in terms of Excel, then use the following path:-
Tools -> Protection->Allow users to Edit Ranges
In this you can have different passwords for different ranges.
Additionally you can also show or hide sheets and protect and
un-protect them using passwords. Workbook pa
Hi Experts
is it possible to make file which having hided and unguided sheets and
open them using different passwords.
Regards
Rajesh kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for
