| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 test please
Greetings,
Could someone with 2002 please run the following test: open a new workbook and add a chart sheet. Add a macro button from the forms toolbar to the chart sheet and assign a macro (sub MacroHello(), msgbox "hello", End Sub). Select Chart sheet and other sheets into a group. Test to see if MacroHello fires. Nothing happens on my machine (i'm running 2002), but Dave Peterson doesn't see a problem when running with Excel 2003 Please advise TIA -- David |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2002 test please
Button works, but with a double click only - must be a bug in 2002?
"David" wrote: Greetings, Could someone with 2002 please run the following test: open a new workbook and add a chart sheet. Add a macro button from the forms toolbar to the chart sheet and assign a macro (sub MacroHello(), msgbox "hello", End Sub). Select Chart sheet and other sheets into a group. Test to see if MacroHello fires. Nothing happens on my machine (i'm running 2002), but Dave Peterson doesn't see a problem when running with Excel 2003 Please advise TIA -- David |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2002 test please
Hi,
I can replicate your findings, of form button only working with a double click when sheets are grouped, in xl2000 and xl2003 (11.6560.6568) SP2 Cheers Andy David wrote: Button works, but with a double click only - must be a bug in 2002? "David" wrote: Greetings, Could someone with 2002 please run the following test: open a new workbook and add a chart sheet. Add a macro button from the forms toolbar to the chart sheet and assign a macro (sub MacroHello(), msgbox "hello", End Sub). Select Chart sheet and other sheets into a group. Test to see if MacroHello fires. Nothing happens on my machine (i'm running 2002), but Dave Peterson doesn't see a problem when running with Excel 2003 Please advise TIA -- David -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2002 test please
Thanks Andy
|
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2002 test please
Tried it with xl2002 and it didn't work... I'll see if I try it on some
other machines today to see what happens. "David" wrote: Greetings, Could someone with 2002 please run the following test: open a new workbook and add a chart sheet. Add a macro button from the forms toolbar to the chart sheet and assign a macro (sub MacroHello(), msgbox "hello", End Sub). Select Chart sheet and other sheets into a group. Test to see if MacroHello fires. Nothing happens on my machine (i'm running 2002), but Dave Peterson doesn't see a problem when running with Excel 2003 Please advise TIA -- David |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2002 test please
Double click will do it in 00,02, and 03
"David" wrote: Thanks Andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
| Logical Test if statements with text--Excel 2002 | Excel Discussion (Misc queries) | |||
| Access 2002 VB Module controlling Excel 2002 spreadsheet -Run-time | Excel Programming | |||
| Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) | |||
| Excel 2002 files attached to Outlook 2002 EMails change size | Excel Programming | |||
Linear Mode
