Hi guys!I would like to design a button (with macros),so that users of my excel page do not need to press CONTROL+SHIFT+F1+ALT,which needs to be pressed on my firm to get the new data from a central server.
Any idea of how to do this??
Thanks beforehand
Eh,
Not sure if I'm reading this right, but to insert a button you'd go to the developer tab, click on Insert, and choose a button, then you click and drag on your sheet to size your new pressy thingy. I use the ActiveX command button for a lot of stuff. While in design mode, double clicking the button will bring up the VBA associated with that button.
mew!
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Hello!!!!!!!!!
Yes, you need Sendkeys.
See http://www.ss64.com/wsh/sendkeys.html
So, you need to send 'F1' while pressing control, shift, and alt...this would be
Try it out. If it doesn't work, then you may need to get a little fancier with windows api's...but it can be done.
Please Login or Register to view this content.
That is exactly what i need. Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks