forms toolbar greyed out

R

revct1

I have Excel 2003. I am trying to create a command button on a screen. I
select View>Toolbars>Form 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?
 
D

Dave Peterson

Is the worksheet protected?
Have you grouped multiple sheets?
Is the workbook shared?
 
R

revct1

Hi Dave,

I checked Tools>Protection 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
 
D

Dave Peterson

One more:

Tools|Options|View Tab|check Show all in the Objects section.

(I'm out of guesses--hope it works.)
 
D

Dave Peterson

[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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top