View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default Using XP Events with Excel 2000 Users

Now that most of my users have upgraded to XP, I've
started using some XP code in my procedures. Some of the
users are still using Excel 2000. To get around that, I
put the procedures that use XP code in a separate module.
Then I do this:

'Where separate module is called XP_Procs
If Application.Version = "10.0" then
Call XP_Procs.MyProcedureWithXPCode
Else
'Version for Excel 2000
End if

This works fine. However, it does not work for events. For
example, I'd like to use the Worsheet_PivotTableUpdate
event. If I as much as put the empty event on a sheet and
an Excel 2000 user pivots the table on that sheet, it will
display an error when it does not recognize the event. I
can't put the worksheet event in a separate module. So...
does anyone know how I can take advantage of XP events in
such a way that Excel 2000 users do not get errors?

tod