Recent content by Trident1

Hi Ken Thanks for your reply but no...I don't think so! What I am talking about is ....If you take a Yes/No option, like Do you want to save changes?, Microsoft have the Yes button highlighted so if you press the return key it will assume yes. Alternatively you can click the Yes key with the...

I work an awful lot in MS Excel and use a considerable amount of macros, a lot of which are assigned to buttons. Can someone please advise me how to enable the user to activate the button by pressing the return key as well as clicking on the button with the mouse?

I've written a macro to find an individuals name in a full column of names, from a normal type of user/password type entry. Having found the name in the column, I want to copy the information contained in the six cells to the right of what is now the activecell, and paste it in another...

Thanks so much PH. Another headache gone without the need for analgesia! Trident

I have decided that I am duplicating an awful lot in my macros. I thought it would be a good idea to use smaller macros and use them one after the other. Assuming that I named these macros: a, b, c, d etc; I am trying to run them one after the other with: Sub runalot() runmacro: a...

Hi all I have written the simplest macro intended to automate the action of : DATA - FORM... on the standard tool bar, which works perfectly well, manually! I have the column labels in A2 to F2 and the required data in the columns thereunder! Rightly or wrongly, I have the following code...

Thank you all for your advice. The worksheet scroll area restriction is brilliant for the tast in hand! The advice on locking up the keys will most certainly be useful in the future. I started to incorporate this method but then changed it in favour of the former. To clarify my tasks for...

Hi Tony Principally, I simply want to keep the users in the set working area. They will be working with their own data so that doesn't pose a problem, but many of them are, how shall we say, are very novice when it comes to even using computers. If they start moving around to see what's...

Thank you so very much. It looks so easy when it's written down for you! You're a saviour!!

I need to add something into an autostart macro that will disable the use of pageup, down and the arrow keys. I have looked through a lot on here but it mainly deals with access. I have established the keycode constants, ie. vbKeyUp is 0x26, vbKeyDown is 0x28 etc. Will someone be kind enough...

Thank you so much for yor trouble. I will endeavour to play with all this information. Mike

Thank you Frederico for your reply. I started to pursue your suggestion and there are literally hundreds of hits on both words; password and worksheet. I really need someone to point me in the direction of these auto open, or whatever they are called, macros. Even if someone can just show me...

I have been using macros in excel for quite a while to automate executions whilst working within the spreadsheet environment. To date, I have not mastered the art of a macro activating when the workbook opens! I have read a few articles on the net about this and it seems that the manner in...