msoscalefromtopleft

I have the following code that will increase the size of a shape when it's clicked, and decreases it to its original size on the second click. Sub Picture2_Click() Dim shp As Shape Dim big As Single, small As Single Dim shpDouH As Double, shpDouOriH As Double big = 2 small = 0.5...

I have created this macro and it works fine on my computer. However, I sent it to coworkers to use on their computers and it does not work. Private Sub Workbook_Open() ' ' MoveDateBoxMain Macro ' ' Sheets("Main").Activate ActiveSheet.Shapes.Range(Array("DTPicker2")).Select...

Hi All, I grabbed this macro code, and it works perfectly, except for one thing, the macro runs on the whole worksheet and I need it to run on only the active cell. I’ve tried adjusting ActiveWorkbook, with ActiveCell, Worksheet with Cell, and a few other things, but nothing seems to work...

I am using the below macro to insert a signature (jpeg file) into a set cell area. When setting the macro the signature is sized to the cell and saved (fits perfectly). When reopening the spreadsheet and selecting the macro button the signature is large and does not appear in the cell that...