I have a workbook that I have added a form to. Most of the time, only
the form will be visible. I added a minimize button to the form which
hides the form and minimizes Excel. To reactivate the form I want to
add a button to one of the spreadsheets in the workbook. However, the
controls in the toolbox are grayed out in this spreadsheet, but not if
I open a new workbook. Any ideas what I am doing wrong? Thanks for
your assistance-

Tamara

Is the sheet protected?

--
Regards,
Tom Ogilvy


"Tamara" wrote in message
om...
I have a workbook that I have added a form to. Most of the time, only
the form will be visible. I added a minimize button to the form which
hides the form and minimizes Excel. To reactivate the form I want to
add a button to one of the spreadsheets in the workbook. However, the
controls in the toolbox are grayed out in this spreadsheet, but not if
I open a new workbook. Any ideas what I am doing wrong? Thanks for
your assistance-

Tamara

Hi Tom,

Thank you for responding. After reading some of the previous posts, I
checked to make sure my workbook was not protected. It is not. I did
create the form which populates the worksheets with data before trying
to add a control to a new worksheet added to the workbook. I created a
shortcut macro to reopen the form, but I would rather have a button on
the spreadsheet. Thanks again-

Tamara



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!