| View previous topic :: View next topic |
| Author |
Message |
ameador
General User
Joined: 08 Jul 2008
Posts: 6
Location: Tucker County, WV
|
 Posted: Tue Jul 08, 2008 5:13 am Post subject: [Solved] Help with Button Control... |
 |
|
I have created a button control on a spreadsheet page. I created a BASIC code sub to clear a group of cells and have set the code to execute when the button is clicked. The problem is that when I click the button, it is acting as though I'm still editing the buttons size and position. It gets the little corner markers for sizing the button and such. How do I make the button "Active" so that clicking it will cause the code to fire instead of it going into this edit mode?
Last edited by ameador on Wed Jul 09, 2008 12:12 pm; edited 1 time in total |
|
| Back to top |
|
 |
Agnisys
Power User
Joined: 10 May 2008
Posts: 58
Location: Noida, India
|
| Posted: Tue Jul 08, 2008 5:30 am Post subject: |
|
|
Make sure View->Toolbars->Form Control is selected.
In the Form Control Toolbar click on the second button from the right that says "Design mode on/off"
Anupam |
|
| Back to top |
|
|
ameador
General User
Joined: 08 Jul 2008
Posts: 6
Location: Tucker County, WV
|
| Posted: Tue Jul 08, 2008 12:32 pm Post subject: Thanks! |
|
|
Thank you for the reply - that was the solution alright!  |
|
| Back to top |
|
|
Agnisys
Power User
Joined: 10 May 2008
Posts: 58
Location: Noida, India
|
| Posted: Wed Jul 09, 2008 4:22 am Post subject: |
|
|
You are welcome. Please mark the subject with a "[solved]".
Thanks,
Anupam. |
|
| Back to top |
|
|
dcapn
General User
Joined: 11 Jan 2011
Posts: 5
Location: Honolulu HI USA
|
| Posted: Fri Apr 13, 2012 4:04 pm Post subject: Clicking on spreadsheet control does not activate; only sele |
|
|
Problem: Clicking on a spreadsheet control does not activate the code it only selects the control for editing; Trying to use the Form Design "Off" does not help this problem. Any suggestions. [Please mark this issue as "Un-solved"]
PS-Using 3.3.0
_________________
Capnmike |
|
| Back to top |
|
|
RPG
Super User
Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland
|
| Posted: Fri Apr 13, 2012 10:49 pm Post subject: |
|
|
Hello
It seems your form is in edit mode. When your form is in edit mode then the macros are not executed.
Romke
_________________
OOo 3.4.5 on openSUSE 12.1
Use this forum : http://user.services.openoffice.org/en/forum |
|
| Back to top |
|
|
dcapn
General User
Joined: 11 Jan 2011
Posts: 5
Location: Honolulu HI USA
|
| Posted: Fri Apr 13, 2012 11:12 pm Post subject: [Solved] Help with Button Control... |
|
|
Yes, I'm sure that you are right about being in form-edit mode, but I can find no way to get the form (or at least the one control on it) out of edit mode; the suggested method of using the "Form Control" toolbar does not work.
_________________
Capnmike |
|
| Back to top |
|
|
RPG
Super User
Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland
|
|
| Back to top |
|
|
|
