Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel 2000 and 2003
I have a program created in 2003 that has a TOC page with links to about 46
sheets. The sheets have the code Private Sub Worksheet_Activate() UserForm1.Show End Sub When I open it in 2003 and click the link, UserForm1 is shown. When I open the same program in 2000. when a user clicks there individual tab, the UserForm is activated, but when they click the link on the TOC page it does not activate the form. Any suggestions. Thanks |
#2
|
|||
|
|||
A longggggg time ago, there was a discussion about this kind of problem (not
with xl2003), though. One suggestion was to get rid of the hyperlinks and use macros to select those other sheets. cwwolfdog wrote: I have a program created in 2003 that has a TOC page with links to about 46 sheets. The sheets have the code Private Sub Worksheet_Activate() UserForm1.Show End Sub When I open it in 2003 and click the link, UserForm1 is shown. When I open the same program in 2000. when a user clicks there individual tab, the UserForm is activated, but when they click the link on the TOC page it does not activate the form. Any suggestions. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2003 V's Excel 2000? | Excel Worksheet Functions | |||
Excel 2000 to Excel 2003.... is it worh it? | Excel Discussion (Misc queries) | |||
How to send Excel 2000 worksheets to Excel 2003? | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |