$$Excel-Macros$$ Shapes in Form

2009-08-04 Thread Tim
Hello all, I'm attempting to have a window pop up when the user clicks a command button on the sheet. The hurdle I have come to is drawing on the form. I have dimensions on the sheet that I want to feed into the "pop-up" for this sketch. What am I missing? I can't get any shape commands to

$$Excel-Macros$$ Need help with password protection code.

2009-01-05 Thread Tim
ior.ColorIndex = 4 End If Next CellBlock Cells(1, 1).Select MsgBox "All assignments for " & Chr(10) & Chr(10) & UCase (FullName) End If Line91: ActiveWorkbook.Protect Password:=PW, St