insert a command button

Hi guys,

Here's my problem:
I want to insert a command button and assign a macro, I have the developers toolbar available with the controls section and on all other spreadsheets i can then select insert and choose the required button, however on the particular workbook i want to use the insert button is greyed out and not available.
i already use macros in this workbook and they work fine from keyboard shortcuts but i would like to make one of them run from a command button
Is there a simple setting somewhere which i may have turned off inadvertently previously or could the problem have anything to do with the macros themselves?

Thanks
Lee

In Properties look at Enabled. Is it TRUE?

Is the sheet protected?

Do you get this problem with other workbooks/

If not is the workbook itself protected?

can you attach the workbook?

You cannot edit VBA in a shared workbook, that includes adding controls.

Please mark your thread solved

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Please mark the Thread solved