Private Sub UserForm_Activate()
Dim ws As Worksheet
Dim myWindow As Window
For Each myWindow In ThisWorkbook.Windows
myWindow.Visible = False
Next myWindow
End Sub
I used the above code inorder to prevent users to see w/book's database.They
can see only userform.
How to make the w/book visible to authorised person ? say to a system
administrator?
what changes need to add to the above code to do the task?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200904/1

I think I would keep the windows visible, but I would hide the worksheet. Then
show the authorized people how to hide/unhide that sheet.



"tkraju via OfficeKB.com" wrote:

Private Sub UserForm_Activate()
Dim ws As Worksheet
Dim myWindow As Window
For Each myWindow In ThisWorkbook.Windows
myWindow.Visible = False
Next myWindow
End Sub
I used the above code inorder to prevent users to see w/book's database.They
can see only userform.
How to make the w/book visible to authorised person ? say to a system
administrator?
what changes need to add to the above code to do the task?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200904/1

--

Dave Peterson