Excel Button on Spreadsheet Prob

K

kbannon

I have a spreadsheet (not userform!) with various textboxes and
buttons. The system works fine except when the user clicks a button it
appears to stay clicked giving the effect of a toggle button (and no-
they aren't toggle buttons :D ).
Although there is VBA behind the buttons there is nothing (that I can
think of) that would cause this.
I have changed various properties for the buttons but nothing seems to
resolve it.
Is it a known issue or what could be the problem?
Excel 11 on windows XP (SP2)
 
G

Guest

This used to annoy me too...There is a 'Take focus on Click' option in the
properties. toodles!
 
K

kbannon

This used to annoy me too...There is a 'Take focus on Click' option in the
properties. toodles!
Click to expand...
Thanks lawson
It still happens with this property set to either true or false!
Killian
 
G

Guest

Would this be the same resolution for my issue? I have a spreadsheet with
several questions each containing 3 command button (yes, no and maybe). If
you click your answer in the first question and then move to the next and
click your answer the selection for question one is gone. how can I get it to
stay checked for each question? I tried to find the "take Focus on click"
option but I am having no luck!

Thanks!
 
D

Dave Peterson

I don't think I've ever seen this.

Could it be a display problem? If you scroll down and up, does the button look
ok?

If it does, maybe you could add a couple of lines to your code.

How about if you minimize the window and then resize it (if the scrolling
doesn't work)?
 
K

kbannon

Scrolling doesn't affect it at all, nor does switching to another
sheet and back again.
Its weird!
 
D

Dave Peterson

Maybe you could add a line like:

activecell.activate

at the end of the code?

Just to test.
 
D

Dave Peterson

How about an irritating suggestion--still untested since I can't duplicate the
problem.

At the end of the macro:

Msgbox "Done!"

End sub

Maybe that'll be enough to help refresh the screen????
 

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

Similar Threads

Need a "save & close" button directly on spreadsheet 1
distributing a spreadsheet with macro buttons 4
Copy button caption 2
Command Button to store a value in Excel/VBA....... 1
Adding a Custom Command Button to the Excel 2007 Ribbon 1
stringed userforms won't hide 6
Unable to assign macros to a new button in the current worksheet 1
User can't see Input boxes 3

Top