HELP NEEDED URGENTLY


Posted by Aiden Murphy on January 09, 2002 1:49 AM

i am creating a navagational system for my major project at college, and there a number of things that i would like help with

Firsty i have a password screen at the beginning and i would like to know how to use the data validation so that if someone enters the wrong password a message box will appear stating that they have entered the wrong password to try again

along with this on the password screen, when i type in the password it comes up exactly the same as i am typing now and i was wondering is there any way of programming this so that it would come up in ***** as it does on like a password screen on a web page as this would be extra security for my system

secondly, i have a large number of command boxes in my system is there anyway of changing the colour of these from the dull boring grey that they are now, also any more advice on the command buttons to jazz them up a bit, is there any way of animating them in any way for example???

fourthly i can get an exit button to work as i dont now the code, i would like it to save the workbook first then bring up a message box saying are you sure you want to exit and then actually exit the system

can u insert noises or music into excel to jazz the system up a bit more for example when u click on a button it makes a noise or when u scroll over it it makes a noise something like that

if any of you out there can help me then please do

thanking u all in advance

Aiden Murphy

PS please email me with the help on murphy_aiden@hotmail.com



Posted by Dan on January 09, 2002 6:43 AM

I can possibly help with a couple of these.

You can change the background color of a command button by going in to the design mode and right-clicking on the command button and choosing Properties. You will want to look for Background Color, and click to edit. As far as animation, Excel doesn't support that, but with Visual Basic coding, anything is possible I suppose.

As far as your password question goes - probably the best way to password protect a workbook is to use Excel's built in function. When you choose Save As, click on the Options button and you can set a password there. The method you describe sounds like it would take all of about 10 seconds to crack the password.