View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default Pop-up message at start-up?

Use a textbox, and set the PasswordChar property to *, this will stop the
text being echoed back when you type it. You will also need to store the
password somewhere, in code, a hidden sheet, or maybe a hidden name.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Daoud Fakhry" wrote in message
...
Thanks Bob,
Sorry to interupt your talking. If I creat a from and put a password in
it,
how I can do that?

Thanks,
Daoud Fakhry

"Bob Phillips" wrote:

Create a userform that does all you want, and launch like so

Private Sub Workbook_Open()
Userform1.Show
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Themis" wrote in message
...
Hello... here's hoping I can get more help, like the wonderful help
I've
received from you people in the past... I have searched high and low
but
came
up with no solution!

What I need to do is have a message box open automatically when my
excel
file is loaded. Ideally, it wouldn't be a msgbox, but rather a nice
normal
box flexible enough so I can change the contents (simple text, most
probably)
easily. Is it possible to launch the contents of a txt or an html file?

Thanks in advance!
Themis