Control Toolbox

[rich]

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]

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?

 

[Guest]

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?

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
(e-mail address removed)
.

 

[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

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?

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
(e-mail address removed)
.