I have an inactive formatting button.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel workbook that has the merge button inactivated. All other
formatting is working.
 
Hi Paula

When you say "inactivated" - Are you able to click it at all
If so what happens.

Button are either form buttons associated to a Macro
or Command Buttons associated with and event ( eg , on click)

It might be that the Command button has its Enabled property set to false
(disabled) by another procedure, or that the Forms button has no macro
associated with it.

HTH
 
You are fortunate.

Now you won't be tempted to merge cells which would give you all sorts of
problems.

The workbook is most likely "shared" which makes merging cells unavailable.


Gord Dibben MS Excel MVP

On Tue, 3 Jul 2007 07:42:03 -0700, Paula Phr <Paula
 
You must log in or register to reply here.

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

Similar Threads

Why is my trace dependents button inactive? 1
Sharing workbooks limitations - Merged Cells 12
How can I check a record to be inactive 1
Excel 2007 Undo Feature With Multiple Workbooks Open 1
Merge & center button grayed out 1
Conditional formatting to color cells 1
Exit Button 1
How to activate inactive Add Ins? 3

Back
Top