I have a workbook where my control toolbox will open but
all of the options are greyed out. How do I reenable
their functionality? Further, what did I do to disable
them. This only happens in this workbook. There is no
write protection. This all started when I noticed a
command button was missing and I wanted to redefine it but
was unable to

Write protection usually refers to protectection of the workbook (readonly).

Do you have the worksheet protected?
Do you have more than one worksheet selected -- Look for [Group] in the title
bar?

rich wrote:

I have a workbook where my control toolbox will open but
all of the options are greyed out. How do I reenable
their functionality? Further, what did I do to disable
them. This only happens in this workbook. There is no
write protection. This all started when I noticed a
command button was missing and I wanted to redefine it but
was unable to

--

Dave Peterson

Check for grouping, there was none.
I did notice that if I copy the cells of the worksheet to
a new book, I regain the missing buttons and the ability
to use the control toolbox.
Is there an easy method to copy all of the sheets and
associated VBA/Macros to a new book?


-----Original Message-----
Write protection usually refers to protectection of the
workbook (readonly).

Do you have the worksheet protected?
Do you have more than one worksheet selected -- Look for
[Group] in the title
bar?

rich wrote:

I have a workbook where my control toolbox will open but
all of the options are greyed out. How do I reenable
their functionality? Further, what did I do to disable
them. This only happens in this workbook. There is no
write protection. This all started when I noticed a
command button was missing and I wanted to redefine it
but
was unable to

--

Dave Peterson

.

Try this first--just in case it works!

rightclick on a worksheet tab
select "select all sheets"
rightclick on a worksheet tab
select move or copy
and copy them to a new workbook

If no, then how about just one sheet at a time:
ctrl-a (twice in xl2003), ctrl-c, and to the new worksheet, ctrl-v

then I'd just copy the code module by module using the same
ctrl-a, ctrl-c, to the new module, ctrl-v




wrote:

Check for grouping, there was none.
I did notice that if I copy the cells of the worksheet to
a new book, I regain the missing buttons and the ability
to use the control toolbox.
Is there an easy method to copy all of the sheets and
associated VBA/Macros to a new book?

-----Original Message-----
Write protection usually refers to protectection of the
workbook (readonly).

Do you have the worksheet protected?
Do you have more than one worksheet selected -- Look for
[Group] in the title
bar?

rich wrote:

I have a workbook where my control toolbox will open but
all of the options are greyed out. How do I reenable
their functionality? Further, what did I do to disable
them. This only happens in this workbook. There is no
write protection. This all started when I noticed a
command button was missing and I wanted to redefine it
but
was unable to

--

Dave Peterson

.


--

Dave Peterson