Good Morning,
I have a routine for inserting a copy of another column. The sheet wil
eventually need to be protected before others in my office can use it
so what I would like to do is to create a delete command button "tied
to the newly created column, so people can add and delete columns a
they need to. But, I have never created a control with code and I nee
some help. If its possible, the button should be placed in the 5th ro
of the column.

Here is my column create code:

Option Explicit

Sub AddMatnonPercent()
Dim MatNON As Range
Dim SCol As Integer
SCol = Range("MatNON").Column + 1
Range("MatNON").Copy
Columns(SCol).Select
Selection.Insert Shift:=xlToRight
Cells(7, SCol).ClearContents
Cells(7, SCol).Select
Application.CutCopyMode = False
End Su

--
Case

-----------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=54371