FUNNY BUTTON
 

I have a command button that shuffles the rows of my
spreadsheet.
When the shuffling is done, the buttons in my
editing/formatting toolbars are dim and non operative.
I have to click on the Design Mode button to release
them, and then once again to exit design mode.
It's like the command button code is not completing
its mission.
I have put toggle breakpoints on the last two lines
of code, and the program runs all the way to the endsub
line.
What would make this occur?

Thanx ahead,
Greg Carter

FUNNY BUTTON
 

If you are using xl97, try changing the TakefocusOnClick property of the the
commandbutton to false.

--
Regards,
Tom Ogilvy

GREG CARTER wrote in message
...
I have a command button that shuffles the rows of my
spreadsheet.
When the shuffling is done, the buttons in my
editing/formatting toolbars are dim and non operative.
I have to click on the Design Mode button to release
them, and then once again to exit design mode.
It's like the command button code is not completing
its mission.
I have put toggle breakpoints on the last two lines
of code, and the program runs all the way to the endsub
line.
What would make this occur?

Thanx ahead,
Greg Carter