Hello there... i want to create a popup which will appear when i wil
open an Excel sheet and ask for user name and password. Please guid
me. Thanks in advance

--
maninde
-----------------------------------------------------------------------
maninder's Profile: http://www.excelforum.com/member.php...fo&userid=3179
View this thread: http://www.excelforum.com/showthread.php?threadid=51520

Hi Maninder,

Any excel file in the following folder will open automatically when Excel
starts

"C:\Documents and Settings\naveen\Application Data\Microsoft\Excel\XLStart\"

Create a form in an Excel file in the above folder. In that form, you can
write the code to accept the user name and password and if they tally you can
allow to enter him to go ahead or you can just quit the excel.

For your reference I have pasted the entire form which I have created for you.

================================================== ===
VERSION 5.00
Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} Welcome
Caption = "Wel Come"
ClientHeight = 3330
ClientLeft = 45
ClientTop = 435
ClientWidth = 4305
OleObjectBlob = "Welcome.frx":0000
StartUpPosition = 1 'CenterOwner
End
Attribute VB_Name = "Welcome"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdOPENEXCEL_Click()
If UCase(txtUNAME.Text) = "NAVEEN" And UCase(txtPWD.Text) = "NAVEEN" Then
End
End If
End Sub

Private Sub cmdQuit_Click()
Application.Quit
End Sub
================================================== ===

With kind regards
NAVEEN


"maninder" wrote:


Hello there... i want to create a popup which will appear when i will
open an Excel sheet and ask for user name and password. Please guide
me. Thanks in advance.


--
maninder
------------------------------------------------------------------------
maninder's Profile: http://www.excelforum.com/member.php...o&userid=31793
View this thread: http://www.excelforum.com/showthread...hreadid=515201