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

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

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

Excel 2002 test please
 

Thanks Andy

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

Excel 2002 test please
 

Double click will do it in 00,02, and 03

"David" wrote:

Thanks Andy