This article describes how to assign an ActiveX CommandButton on a worksheet to a member of a custom class in a VBA project. When creating an application in Excel it is likely that somewhere you will want one or more clickable “buttons” in a sheet. A quick and easy way of doing this is to add a “Shape” to the sheet, right-clicking it and selecting “Assign Macro”. You can then write code that will run when the shape is clicked by a user. This is a neat solution because the app

When you add a hyperlink to a cell in Excel, it automatically applies the Hyperlink style (blue font, underlined). Sometime I want to add hyperlinks but preserve the formatting in the cell I’m adding the hyperlink to, but there is no option in Excel to do this. Deleting the “Hyperlink” style does not work either, as it reappears automatically. I searched all over the net for an answer to this but couldn’t find one. The vast majority of answers apply to the question of how to