• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Restrict user from going to another sheet

abdulncr

Member
Hi,


I have a workbook used by many user,sheet tab is hidden, from the home page user directed to concerned sheet by user id and pw throgh the Form and VBA.


User cant see the another sheet, still they can use Find function search in workbook and reach to any sheet thy wish to. any solution for this... like disable search in workbook


Thanks


Abdul
 
Hi !     Maybe you could use the VBA ThisWorkbook module class' event Workbook_SheetActivate

          to check the user and the active sheet …
 
Hi, abdulncr!


As Marc L wrote you can place this code in ThisWorkbook module:

-----

[pre]
Code:
Option Explicit

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Worksheets("Hoja1").Activate
End Sub
-----


Or this one in your worksheet module:

-----

Option Explicit

Private Sub Worksheet_Deactivate()
Worksheets("Hoja1").Activate
End Sub
[/pre]
-----


Examples with worksheet Hoja1.


Regards!
 
Hi,


I tried in the workbook module.


it is restricting the search what i wanted, butit is restricting the user also who login with user id and pw using Form.


Thanks


Abdul
 
Back
Top