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