| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
forms toolbar greyed out
I have Excel 2003. I am trying to create a command button on a screen. I
select ViewToolbarsForm and the toolbar appears but is greyed out. It won't allow me to left click the command button on the toolbar and create it on the screen. I can open a new notebook and create the command button there but not on the existing notebook. I have tried to copy a command button from the new notebook to the existing notebook and receive a pop up stating "Microsoft Excel cannot paste the data". The other toolbars are available and not greyed out. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
forms toolbar greyed out
Is the worksheet protected?
Have you grouped multiple sheets? Is the workbook shared? revct1 wrote: I have Excel 2003. I am trying to create a command button on a screen. I select ViewToolbarsForm and the toolbar appears but is greyed out. It won't allow me to left click the command button on the toolbar and create it on the screen. I can open a new notebook and create the command button there but not on the existing notebook. I have tried to copy a command button from the new notebook to the existing notebook and receive a pop up stating "Microsoft Excel cannot paste the data". The other toolbars are available and not greyed out. Any suggestions? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
forms toolbar greyed out
Hi Dave,
I checked ToolsProtection and it gives me the option to "Protect Sheet" but currently the sheet is not protected. The sheets are not grouped (no "GROUP" word in the title bar) and the workbook is not shared (at least not by other computers). Am I missing something? Where do I look next? Thanks Jack "Dave Peterson" wrote: Is the worksheet protected? Have you grouped multiple sheets? Is the workbook shared? revct1 wrote: I have Excel 2003. I am trying to create a command button on a screen. I select ViewToolbarsForm and the toolbar appears but is greyed out. It won't allow me to left click the command button on the toolbar and create it on the screen. I can open a new notebook and create the command button there but not on the existing notebook. I have tried to copy a command button from the new notebook to the existing notebook and receive a pop up stating "Microsoft Excel cannot paste the data". The other toolbars are available and not greyed out. Any suggestions? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
forms toolbar greyed out
One mo
Tools|Options|View Tab|check Show all in the Objects section. (I'm out of guesses--hope it works.) revct1 wrote: Hi Dave, I checked ToolsProtection and it gives me the option to "Protect Sheet" but currently the sheet is not protected. The sheets are not grouped (no "GROUP" word in the title bar) and the workbook is not shared (at least not by other computers). Am I missing something? Where do I look next? Thanks Jack "Dave Peterson" wrote: Is the worksheet protected? Have you grouped multiple sheets? Is the workbook shared? revct1 wrote: I have Excel 2003. I am trying to create a command button on a screen. I select ViewToolbarsForm and the toolbar appears but is greyed out. It won't allow me to left click the command button on the toolbar and create it on the screen. I can open a new notebook and create the command button there but not on the existing notebook. I have tried to copy a command button from the new notebook to the existing notebook and receive a pop up stating "Microsoft Excel cannot paste the data". The other toolbars are available and not greyed out. Any suggestions? -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
forms toolbar greyed out
That's the one.
Gord On Fri, 01 Feb 2008 13:18:06 -0600, Dave Peterson wrote: One mo Tools|Options|View Tab|check Show all in the Objects section. (I'm out of guesses--hope it works.) revct1 wrote: Hi Dave, I checked ToolsProtection and it gives me the option to "Protect Sheet" but currently the sheet is not protected. The sheets are not grouped (no "GROUP" word in the title bar) and the workbook is not shared (at least not by other computers). Am I missing something? Where do I look next? Thanks Jack "Dave Peterson" wrote: Is the worksheet protected? Have you grouped multiple sheets? Is the workbook shared? revct1 wrote: I have Excel 2003. I am trying to create a command button on a screen. I select ViewToolbarsForm and the toolbar appears but is greyed out. It won't allow me to left click the command button on the toolbar and create it on the screen. I can open a new notebook and create the command button there but not on the existing notebook. I have tried to copy a command button from the new notebook to the existing notebook and receive a pop up stating "Microsoft Excel cannot paste the data". The other toolbars are available and not greyed out. Any suggestions? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
forms toolbar greyed out
Why wasn't one of the others the "one"?
<vbg Gord Dibben wrote: That's the one. Gord On Fri, 01 Feb 2008 13:18:06 -0600, Dave Peterson wrote: One mo Tools|Options|View Tab|check Show all in the Objects section. (I'm out of guesses--hope it works.) revct1 wrote: Hi Dave, I checked ToolsProtection and it gives me the option to "Protect Sheet" but currently the sheet is not protected. The sheets are not grouped (no "GROUP" word in the title bar) and the workbook is not shared (at least not by other computers). Am I missing something? Where do I look next? Thanks Jack "Dave Peterson" wrote: Is the worksheet protected? Have you grouped multiple sheets? Is the workbook shared? revct1 wrote: I have Excel 2003. I am trying to create a command button on a screen. I select ViewToolbarsForm and the toolbar appears but is greyed out. It won't allow me to left click the command button on the toolbar and create it on the screen. I can open a new notebook and create the command button there but not on the existing notebook. I have tried to copy a command button from the new notebook to the existing notebook and receive a pop up stating "Microsoft Excel cannot paste the data". The other toolbars are available and not greyed out. Any suggestions? -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
forms toolbar greyed out
You were out of guesses so it had to be "the one".
Gord On Fri, 01 Feb 2008 16:20:04 -0600, Dave Peterson wrote: Why wasn't one of the others the "one"? <vbg Gord Dibben wrote: That's the one. Gord On Fri, 01 Feb 2008 13:18:06 -0600, Dave Peterson wrote: One mo Tools|Options|View Tab|check Show all in the Objects section. (I'm out of guesses--hope it works.) revct1 wrote: Hi Dave, I checked ToolsProtection and it gives me the option to "Protect Sheet" but currently the sheet is not protected. The sheets are not grouped (no "GROUP" word in the title bar) and the workbook is not shared (at least not by other computers). Am I missing something? Where do I look next? Thanks Jack "Dave Peterson" wrote: Is the worksheet protected? Have you grouped multiple sheets? Is the workbook shared? revct1 wrote: I have Excel 2003. I am trying to create a command button on a screen. I select ViewToolbarsForm and the toolbar appears but is greyed out. It won't allow me to left click the command button on the toolbar and create it on the screen. I can open a new notebook and create the command button there but not on the existing notebook. I have tried to copy a command button from the new notebook to the existing notebook and receive a pop up stating "Microsoft Excel cannot paste the data". The other toolbars are available and not greyed out. Any suggestions? -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
forms toolbar greyed out
You must be psychic!
Gord Dibben wrote: You were out of guesses so it had to be "the one". Gord On Fri, 01 Feb 2008 16:20:04 -0600, Dave Peterson wrote: Why wasn't one of the others the "one"? <vbg Gord Dibben wrote: That's the one. Gord On Fri, 01 Feb 2008 13:18:06 -0600, Dave Peterson wrote: One mo Tools|Options|View Tab|check Show all in the Objects section. (I'm out of guesses--hope it works.) revct1 wrote: Hi Dave, I checked ToolsProtection and it gives me the option to "Protect Sheet" but currently the sheet is not protected. The sheets are not grouped (no "GROUP" word in the title bar) and the workbook is not shared (at least not by other computers). Am I missing something? Where do I look next? Thanks Jack "Dave Peterson" wrote: Is the worksheet protected? Have you grouped multiple sheets? Is the workbook shared? revct1 wrote: I have Excel 2003. I am trying to create a command button on a screen. I select ViewToolbarsForm and the toolbar appears but is greyed out. It won't allow me to left click the command button on the toolbar and create it on the screen. I can open a new notebook and create the command button there but not on the existing notebook. I have tried to copy a command button from the new notebook to the existing notebook and receive a pop up stating "Microsoft Excel cannot paste the data". The other toolbars are available and not greyed out. Any suggestions? -- Dave Peterson -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
forms toolbar greyed out
I have the same problem... But mine shows the "Group" at the title bar. What does that mean? What do I need to do to create a command button? *** Sent via Developersdex http://www.developersdex.com *** |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
forms toolbar greyed out
[Group]
in the title bar means that you have multiple sheets selected. Rightclick on one of the selected sheet tabs and choose "Ungroup sheets". Then try using the controls again. And to create a commandbutton, you have to use the control toolbox toolbar. The commandbutton on the control toolbox toolbar is different from the button on the Forms toolbar. Karen Yee wrote: I have the same problem... But mine shows the "Group" at the title bar. What does that mean? What do I need to do to create a command button? *** Sent via Developersdex http://www.developersdex.com *** -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External Data Toolbar permanently greyed out. | Excel Discussion (Misc queries) | |||
| Forms Toolbar | Excel Discussion (Misc queries) | |||
| Paste function is greyed out in the toolbar and I can't use ctl V - worksheet won't allow pasting | Excel Discussion (Misc queries) | |||
| Why are some commands in Excel's Drawing Toolbar greyed-out (eg T. | Excel Discussion (Misc queries) | |||
| why are the options on my forms menu greyed out? | Excel Programming | |||
Linear Mode
