Button properties blank: protection problem?

  • Thread starter Thread starter George
  • Start date Start date
G

George

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
 
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???
 
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???
Click to expand...

No - that does the same thing.

George
 
Sorry, I don't have another guess.

If you delete the commandbutton and re-add it, does it behave nice?
 
Sorry, I don't have another guess.

If you delete the commandbutton and re-add it, does it behave nice?
Click to expand...

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
 
Thanks for posting back. I had never noticed that.

But protecting the project stops a lot of stuff from being seen by the user.
 
Back
Top