Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DerfLongshanks

    code crashes on one machine, but not another

    I have had a similar problem, which I found was caused by the page setup options. The original machine was setup for A3 and the second machine A4, once I had changed this it worked correctly. Hope this helps
  2. DerfLongshanks

    Excel Worksheet_activate hide columns

    the do until test will be true every time it finds a blank cell so it will never excute the code to unhide the cells Try this instead Private Sub Worksheet_Activate() Dim I As Integer I = 9 ' Application.ScreenUpdating = False Columns("I").Select Do Until I =...
  3. DerfLongshanks

    Mouse Button swapping

    Thanks for the above, Microsoft Intellipoint software is available on their website and works fine with my genius mouse. "Failure comes only when one stops making an effort" Matsushita Konosuke
  4. DerfLongshanks

    Mouse Button swapping

    I currently use the mouse left handed but some programs I run lock up when it is configured that way, ususally I remember to change the mouse buttons over after starting the program and it locks up. This can be annoying so I am trying to have it swap buttons automaticly when I start the program...
  5. DerfLongshanks

    Cell LOSTFOCUS event

    As I understand your request try using the selection change event example Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) MsgBox "ha ha", vbDefaultButton1 End Sub Derf If you don't have to run, walk, if you don't have to walk, sit, if you don't have to...

Part and Inventory Search

Back
Top