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
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 =...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.