View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default I can't insert a Command Button into my spreadsheet

It is dimmed out if the workbook is shared (but then you shouldn't be able
to change protection).

--
Regards,
Tom Ogilvy

"Stephen238" wrote in message
...
I have the toolbar out and watch it as I enter the password to unprotect

the
sheet. It seems like it should light up at that point, but nothing

happens.
Is there anything else that it could be?

"Tom Ogilvy" wrote:

That is usually symptomatic of a protected sheet. I would look again

about
the protection.

--
Regards,
Tom Ogilvy


"Stephen238" wrote in message
...
I am trying to create a command button in one my excel spreadsheets

and I
can't insert the button for some reason. I am able to in other files,

but
for some reason, when I view the Forms toolbar, none of the options

light
up...they all remain dim. I had been playing around with different

types
of
protection with this file, but they are all off now. Any ideas on

what
could
be making this spreadsheet different from my others or what I could be

doing
wrong?