Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Button properties blank: protection problem?
From the 'controls toolbox', I select a button, right-click, and select
'properties'. A dialog comes up, but it's blank. My understanding is that this is because something is protected. However, ... - AFAICT, the sheet is not locked. As in, menubar <tools - protection just shows "protect sheet" - no "unprotect". - Other editing of the button is allowed: I can re-size it, move it, edit the name ('commandButton object'), etc. I do use protection in this workbook. Other WB's, w/o protection, do not have this problem. Any thoughts would be appreciated. I'm kind of out of bullets. TIA, George |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Button properties blank: protection problem?
On Mon, 12 Nov 2007 13:11:32 GMT, George wrote:
I should add: Excel 2002. From the 'controls toolbox', I select a button, right-click, and select 'properties'. A dialog comes up, but it's blank. My understanding is that this is because something is protected. However, ... - AFAICT, the sheet is not locked. As in, menubar <tools - protection just shows "protect sheet" - no "unprotect". - Other editing of the button is allowed: I can re-size it, move it, edit the name ('commandButton object'), etc. I do use protection in this workbook. Other WB's, w/o protection, do not have this problem. Any thoughts would be appreciated. I'm kind of out of bullets. TIA, George |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Button properties blank: protection problem?
I've never seen that behavior.
But I have seen a problem that when the commandbutton is added to a worksheet via code, then when I rightclick on the commandbutton, neither Properties nor Show Code is showing (but an option to Show Picture toolbar is shown). But I can get to the properties dialog via the button on the control toolbox toolbar. Select the commandbutton first, then click that properties button on the toolbar. Maybe it'll help for you??? George wrote: From the 'controls toolbox', I select a button, right-click, and select 'properties'. A dialog comes up, but it's blank. My understanding is that this is because something is protected. However, ... - AFAICT, the sheet is not locked. As in, menubar <tools - protection just shows "protect sheet" - no "unprotect". - Other editing of the button is allowed: I can re-size it, move it, edit the name ('commandButton object'), etc. I do use protection in this workbook. Other WB's, w/o protection, do not have this problem. Any thoughts would be appreciated. I'm kind of out of bullets. TIA, George -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Button properties blank: protection problem?
On Mon, 12 Nov 2007 09:00:09 -0600, Dave Peterson
wrote: I've never seen that behavior. But I have seen a problem that when the commandbutton is added to a worksheet via code, then when I rightclick on the commandbutton, neither Properties nor Show Code is showing (but an option to Show Picture toolbar is shown). But I can get to the properties dialog via the button on the control toolbox toolbar. Select the commandbutton first, then click that properties button on the toolbar. Maybe it'll help for you??? No - that does the same thing. George George wrote: From the 'controls toolbox', I select a button, right-click, and select 'properties'. A dialog comes up, but it's blank. My understanding is that this is because something is protected. However, ... - AFAICT, the sheet is not locked. As in, menubar <tools - protection just shows "protect sheet" - no "unprotect". - Other editing of the button is allowed: I can re-size it, move it, edit the name ('commandButton object'), etc. I do use protection in this workbook. Other WB's, w/o protection, do not have this problem. Any thoughts would be appreciated. I'm kind of out of bullets. TIA, George |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Button properties blank: protection problem?
Sorry, I don't have another guess.
If you delete the commandbutton and re-add it, does it behave nice? George wrote: On Mon, 12 Nov 2007 09:00:09 -0600, Dave Peterson wrote: I've never seen that behavior. But I have seen a problem that when the commandbutton is added to a worksheet via code, then when I rightclick on the commandbutton, neither Properties nor Show Code is showing (but an option to Show Picture toolbar is shown). But I can get to the properties dialog via the button on the control toolbox toolbar. Select the commandbutton first, then click that properties button on the toolbar. Maybe it'll help for you??? No - that does the same thing. George George wrote: From the 'controls toolbox', I select a button, right-click, and select 'properties'. A dialog comes up, but it's blank. My understanding is that this is because something is protected. However, ... - AFAICT, the sheet is not locked. As in, menubar <tools - protection just shows "protect sheet" - no "unprotect". - Other editing of the button is allowed: I can re-size it, move it, edit the name ('commandButton object'), etc. I do use protection in this workbook. Other WB's, w/o protection, do not have this problem. Any thoughts would be appreciated. I'm kind of out of bullets. TIA, George -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Button properties blank: protection problem?
On Mon, 12 Nov 2007 11:16:12 -0600, Dave Peterson
wrote: Sorry, I don't have another guess. If you delete the commandbutton and re-add it, does it behave nice? Problem solved, though I don't understand why: I have VBA code for this WB, and VB is password protected. Once I opened the VB window (and entered the password), the buttons' properties became visible. Probably that makes sense. Anyway, thanks, George |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Button properties blank: protection problem?
Thanks for posting back. I had never noticed that.
But protecting the project stops a lot of stuff from being seen by the user. George wrote: On Mon, 12 Nov 2007 11:16:12 -0600, Dave Peterson wrote: Sorry, I don't have another guess. If you delete the commandbutton and re-add it, does it behave nice? Problem solved, though I don't understand why: I have VBA code for this WB, and VB is password protected. Once I opened the VB window (and entered the password), the buttons' properties became visible. Probably that makes sense. Anyway, thanks, George -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
button properties | Excel Discussion (Misc queries) | |||
Command Button Control Properties | Excel Discussion (Misc queries) | |||
Document Properties are Blank in Office 2007 | Excel Discussion (Misc queries) | |||
command button properties | Excel Worksheet Functions | |||
Spinner Button properties | Excel Discussion (Misc queries) |