hiding sheet --authorised use only

arjaffari

Board Regular
Joined
Jul 5, 2008
Messages
61
is there any way so the sheets may be hidden for any unauthorized use and may only be viewable by authorized persons
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Stormseed

Banned
Joined
Sep 18, 2006
Messages
3,274
is there any way so the sheets may be hidden for any unauthorized use and may only be viewable by authorized persons

I think this is the same question you asked one more time.

Follow these steps:

Excel menubar --> click on Format --> Sheet --> Hide. Next, protect your worksheet with a password. This will help you to accomplish your question requirement.

In order to protect your worksheet with a password:

Excel Menubar --> Click on Tools --> Protection --> Protect Sheet --> Apply Password and you are done.
 

soodaarti21

New Member
Joined
Jun 30, 2008
Messages
48
the process has only one problem when the application is distributed and we dont want everybody to see or access the hidden sheets except from the autorised person.

In this case is there a way out???
 

AlexM

Board Regular
Joined
Feb 14, 2007
Messages
132
You can unhide sheets using a macro, which could be executed only by authorised person.
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,916
something like this in the ThisWorkbook module might work.

Code:
Dim LastSheet as Worksheet

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    Dim showSheet As Worksheet
    If Sh.Name = "SecretSheet" Then
        Application.EnableEvents = False
        lastSheet.Activate
        Set showSheet = IIf(Application.InputBox("What is the password", Type:=2) = "password", Sh, lastSheet)
        showSheet.Activate
        Application.EnableEvents = True
    End If
End Sub

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
    Set lastSheet = Sh
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,122,909
Messages
5,598,796
Members
414,259
Latest member
beetle12

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top