Hello Team Can someone help as to why buttons on an Excel spreadsheet are not working? The sheet is locked, but the buttons have been set as unlocked. The sheet is not in ‘design mode’. But when you click a button, the ‘white-dots’ (shape selected) appear and the code is not fired. What is wrong? Thank you! Steve
Thanks for the reply, MrkFrrl
What is the difference between a command button and a form button? I see them both on the tools list. I take it you can add either on a worksheet.
Steve
It’s either in design mode (though you say it’s not), or your workbook (if not Excel itself) is somehow corrupted. What happens when you click on the design-mode button to deselect it? You might try using a form button instead of a command button.