Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Forms toolbar is grayed out - need a check box
For some reason the buttons on the Forms Toolbar (all bar the Toggle Grid
one) are grayed out. When I open a new work book they are available. I have been working on this workbook for some time. I am not aware of anything that I have done to have caused this. Possibly a mi**** key along the way. I just need a check box!!!!! Please help Thanks Rob |
#2
|
|||
|
|||
Is your worksheet protected?
************ Anne Troy www.OfficeArticles.com "Rob" wrote in message ... For some reason the buttons on the Forms Toolbar (all bar the Toggle Grid one) are grayed out. When I open a new work book they are available. I have been working on this workbook for some time. I am not aware of anything that I have done to have caused this. Possibly a mi**** key along the way. I just need a check box!!!!! Please help Thanks Rob |
#3
|
|||
|
|||
No - A password is required to open but there are no other protection
features used. I have tried saving a copy of the worksheet without a password to open - this didn't resolve the issue. Thanks for your response. Rob "Anne Troy" wrote: Is your worksheet protected? ************ Anne Troy www.OfficeArticles.com "Rob" wrote in message ... For some reason the buttons on the Forms Toolbar (all bar the Toggle Grid one) are grayed out. When I open a new work book they are available. I have been working on this workbook for some time. I am not aware of anything that I have done to have caused this. Possibly a mi**** key along the way. I just need a check box!!!!! Please help Thanks Rob |
#4
|
|||
|
|||
Hmmm... Perhaps you have it shared? (Tools--Share workbook) When I tested
this, the forms toolbar components are all grayed out. See limitations: http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Rob" wrote in message ... No - A password is required to open but there are no other protection features used. I have tried saving a copy of the worksheet without a password to open - this didn't resolve the issue. Thanks for your response. Rob "Anne Troy" wrote: Is your worksheet protected? ************ Anne Troy www.OfficeArticles.com "Rob" wrote in message ... For some reason the buttons on the Forms Toolbar (all bar the Toggle Grid one) are grayed out. When I open a new work book they are available. I have been working on this workbook for some time. I am not aware of anything that I have done to have caused this. Possibly a mi**** key along the way. I just need a check box!!!!! Please help Thanks Rob |
#5
|
|||
|
|||
Do you have multiple sheets grouped together?
Rob wrote: For some reason the buttons on the Forms Toolbar (all bar the Toggle Grid one) are grayed out. When I open a new work book they are available. I have been working on this workbook for some time. I am not aware of anything that I have done to have caused this. Possibly a mi**** key along the way. I just need a check box!!!!! Please help Thanks Rob -- Dave Peterson |
#6
|
|||
|
|||
I had a look at Tools - Share Workbook and the allow other users is unchecked. I went through the process of checking and un checking and tried this on a different workbook as well. I agree it does gray out the forms, but when unchecked, functionality returns. I still have a grayed out Forms toolbar. It must be something like this...I have spent hours going through menus. Thanks again - I appreciate the help Rob "Anne Troy" wrote: Hmmm... Perhaps you have it shared? (Tools--Share workbook) When I tested this, the forms toolbar components are all grayed out. See limitations: http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Rob" wrote in message ... No - A password is required to open but there are no other protection features used. I have tried saving a copy of the worksheet without a password to open - this didn't resolve the issue. Thanks for your response. Rob "Anne Troy" wrote: Is your worksheet protected? ************ Anne Troy www.OfficeArticles.com "Rob" wrote in message ... For some reason the buttons on the Forms Toolbar (all bar the Toggle Grid one) are grayed out. When I open a new work book they are available. I have been working on this workbook for some time. I am not aware of anything that I have done to have caused this. Possibly a mi**** key along the way. I just need a check box!!!!! Please help Thanks Rob |
#7
|
|||
|
|||
There are a reasonably large number of sheets - about 14 in total. As
mentioned I have been working on this for some time. I don't understand what you mean by multiple sheets "grouped" together though? Thanks Rob "Dave Peterson" wrote: Do you have multiple sheets grouped together? Rob wrote: For some reason the buttons on the Forms Toolbar (all bar the Toggle Grid one) are grayed out. When I open a new work book they are available. I have been working on this workbook for some time. I am not aware of anything that I have done to have caused this. Possibly a mi**** key along the way. I just need a check box!!!!! Please help Thanks Rob -- Dave Peterson |
#8
|
|||
|
|||
I have right clicked the tabs on each of the sheets. None of them offer me
the option to ungroup sheets. Rob "Dave Peterson" wrote: Do you have multiple sheets grouped together? Rob wrote: For some reason the buttons on the Forms Toolbar (all bar the Toggle Grid one) are grayed out. When I open a new work book they are available. I have been working on this workbook for some time. I am not aware of anything that I have done to have caused this. Possibly a mi**** key along the way. I just need a check box!!!!! Please help Thanks Rob -- Dave Peterson |
#9
|
|||
|
|||
You could also see [Group] in the title bar.
(I don't have another guess.) Rob wrote: I have right clicked the tabs on each of the sheets. None of them offer me the option to ungroup sheets. Rob "Dave Peterson" wrote: Do you have multiple sheets grouped together? Rob wrote: For some reason the buttons on the Forms Toolbar (all bar the Toggle Grid one) are grayed out. When I open a new work book they are available. I have been working on this workbook for some time. I am not aware of anything that I have done to have caused this. Possibly a mi**** key along the way. I just need a check box!!!!! Please help Thanks Rob -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check box in Forms Toolbar | Excel Discussion (Misc queries) | |||
How can I hide check box created via FORMS together with column? | Excel Discussion (Misc queries) | |||
Forms Check Box Font Size | Excel Discussion (Misc queries) | |||
Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |