button click

I have the following Macro which adds a glow to a shape when clicked. Sub IsoscelesTriangle2_Click() ' ' IsoscelesTriangle2_Click Macro Dim Shp As Shape Set Shp = ActiveSheet.Shapes(Application.Caller) With Shp.Glow .Color = RGB(0, 255, 0) .Radius = IIf(.Radius...

I've a couple rectangles working as buttons with hyperlinks to other worksheets. However, I'm wanting to add a glow or some kind of action when a rectangle is clicked (and "unglow" when another is clicked) to simulate the button function <COLGROUP><COL style="WIDTH: 83pt; mso-width-source...

Hello. I am trying to build a code which hides entire rows based on the value of two cells. I put the code and an example to a better understanding of my issue. The code is not working, it is giving me an error. CODE: Private Sub Hide_Click() RowNumber = 1 Do DoEvents RowNumber = RowNumber...

Please Help! I included a code for send emails on button click with multiple cell values which comes in column A and B. These column are selected using dynamically generated checkboxes. I’m able to create dynamic checkboxes but I failed to retrieve the cell values to a variable. While I’m...

Hi Team, Once again, I would really appricate your help! Background: I am creating a workbook - where the user selects difference criteria (slicers), which specifies which worksheet is relevent (out of 26 different options). The user then inputs some varible which in turns updates the...

I have a subroutine that works the way I want but I also want to tie it to a button with a message, "Are you sure you want to..." Is there is a way to tell if the program is called from another routine or from the button click.