FUNNY BUTTON

  • Thread starter Thread starter GREG CARTER
  • Start date Start date
G

GREG CARTER

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
 
If you are using xl97, try changing the TakefocusOnClick property of the the
commandbutton to false.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top