Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Button on Spreadsheet Prob
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Button on Spreadsheet Prob
This used to annoy me too...There is a 'Take focus on Click' option in the
properties. toodles! "kbannon" wrote: 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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Button on Spreadsheet Prob
On Jun 26, 4:50 pm, lawson wrote:
This used to annoy me too...There is a 'Take focus on Click' option in the properties. toodles! Thanks lawson It still happens with this property set to either true or false! Killian |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Button on Spreadsheet Prob
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! "lawson" wrote: This used to annoy me too...There is a 'Take focus on Click' option in the properties. toodles! "kbannon" wrote: 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) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Button on Spreadsheet Prob
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)? kbannon wrote: 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) -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Button on Spreadsheet Prob
Scrolling doesn't affect it at all, nor does switching to another
sheet and back again. Its weird! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Button on Spreadsheet Prob
Maybe you could add a line like:
activecell.activate at the end of the code? Just to test. kbannon wrote: Scrolling doesn't affect it at all, nor does switching to another sheet and back again. Its weird! -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Button on Spreadsheet Prob
Nope - activecell.activate helped but does not consistently resolve
the issue. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Button on Spreadsheet Prob
I'm out of ideas.
kbannon wrote: Nope - activecell.activate helped but does not consistently resolve the issue. -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Button on Spreadsheet Prob
You and me both!
Thanks for the help Dave |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Button on Spreadsheet Prob
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???? kbannon wrote: You and me both! Thanks for the help Dave -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel function button in spreadsheet | Excel Discussion (Misc queries) | |||
Excel function button in spreadsheet | Links and Linking in Excel | |||
my excel spreadsheet right scroll button disappears during use | Excel Discussion (Misc queries) | |||
spreadsheet not working prob | Excel Discussion (Misc queries) | |||
How do I put a button on an excel spreadsheet to print a report? | Excel Discussion (Misc queries) |