Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2000, format changes from users | Excel Discussion (Misc queries) | |||
Prevent users from adding rows in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 Formula Not Working Other Users | Excel Discussion (Misc queries) | |||
allow users to edit a range in excel 2000 | Excel Discussion (Misc queries) | |||
How-To - Forwarding Excel 2000 events to .Net application | Excel Programming |