LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
DKS DKS is offline
external usenet poster
 
Posts: 103
Default XP macros not working in NT

I have few .xls with macros written and tested on XP based Excel. However,
the same .xls when used on NT based Excel generate a Dr. Watson. All the
macro statements are perfectly compatible with NT version, no fancy features
used.

Any idea on what could be the potential cause of the error? To help you
zoom in the problem I have reproduced one of the many macros that generate a
Dr. Watson on NT machines.

Thanks a lot for your help.

Sub Select_View()
'
' Select_View Macro
' Based on user selection, a filter in column of business view is activated.
' This column is a hidden column, thus first step is to unhide the column.
' Next step is to apply approrpriate filter criteria
' Last step is to re-hide the column
'

'
r = MsgBox("Do you want only Business View? (Yes = Only Business view,
No = Entire view)", vbYesNo, "Select View")
Selection.AutoFilter Field:=4, Criteria1:="<"
Range("A1").Select
ActiveSheet.ShowAllData
ActiveCell.Select
If r = vbYes Then
ActiveCell.Offset(0, 16).Columns("A:C").EntireColumn.Select
Selection.EntireColumn.Hidden = False
Selection.AutoFilter Field:=17, Criteria1:="Yes"
Range("A1").Select
ActiveCell.Offset(0, 16).Columns("A").EntireColumn.Select
Selection.EntireColumn.Hidden = True
Range("A1").Select
Else
If r = vbNo Then
Range("A1").Select
Else
r = MsgBox("error in reply", vbOKCancel, "msg")
End If
End If
ActiveWindow.Visible = True
End Sub
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007/macros not working hughesdm Excel Worksheet Functions 1 April 23rd 09 03:28 PM
Macros not working when file run on a Mac Darby Excel Discussion (Misc queries) 4 November 5th 07 02:49 PM
Working with Macros - Help needed!!! The Greek Excel Discussion (Misc queries) 2 November 19th 06 05:39 PM
HELP : Excel 4 macros not working any more Keske Saram Excel Programming 7 August 6th 05 02:29 AM
Advise, please, how to get the following macros working: LikBez Excel Programming 0 August 19th 03 08:53 AM


All times are GMT +1. The time now is 12:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ╘2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"