Excel button
 

I have a workbook that had a macro that did not work in
it. The macro was started by a button that is sitting on
the worksheet.

This is in sheet1 on the vb editor

Private Sub btnImport_Click()

End Sub

If I delete it it comes back. How do I get rid of this
button. I am unable to select it on the worksheet. I
have replace the macro on sheet1 with one that runs in
Module1 and can not figure out haw to remove or reassign
this button.

Thanks
Mike

Excel button
 

viewtoolscontrol toolboxclick on design mode (below the C) now you can
select & re-assign or cut. Best to use buttons from the forms toolbar or
shapes. Then you don't have this problem.

--
Don Guillett
SalesAid Software

"Mike D" wrote in message
...
I have a workbook that had a macro that did not work in
it. The macro was started by a button that is sitting on
the worksheet.

This is in sheet1 on the vb editor

Private Sub btnImport_Click()

End Sub

If I delete it it comes back. How do I get rid of this
button. I am unable to select it on the worksheet. I
have replace the macro on sheet1 with one that runs in
Module1 and can not figure out haw to remove or reassign
this button.

Thanks
Mike

Excel button
 

Thanks that was it. I had never seen a button added this
way.

Mike


-----Original Message-----
viewtoolscontrol toolboxclick on design mode (below
the C) now you can
select & re-assign or cut. Best to use buttons from the
forms toolbar or
shapes. Then you don't have this problem.

--
Don Guillett
SalesAid Software

"Mike D" wrote in
message
...
I have a workbook that had a macro that did not work in
it. The macro was started by a button that is sitting
on
the worksheet.

This is in sheet1 on the vb editor

Private Sub btnImport_Click()

End Sub

If I delete it it comes back. How do I get rid of this
button. I am unable to select it on the worksheet. I
have replace the macro on sheet1 with one that runs in
Module1 and can not figure out haw to remove or reassign
this button.

Thanks
Mike


.

Excel button
 

glad it worked for you.

--
Don Guillett
SalesAid Software

"Mike D" wrote in message
...
Thanks that was it. I had never seen a button added this
way.

Mike


-----Original Message-----
viewtoolscontrol toolboxclick on design mode (below
the C) now you can
select & re-assign or cut. Best to use buttons from the
forms toolbar or
shapes. Then you don't have this problem.

--
Don Guillett
SalesAid Software

"Mike D" wrote in
message
...
I have a workbook that had a macro that did not work in
it. The macro was started by a button that is sitting
on
the worksheet.

This is in sheet1 on the vb editor

Private Sub btnImport_Click()

End Sub

If I delete it it comes back. How do I get rid of this
button. I am unable to select it on the worksheet. I
have replace the macro on sheet1 with one that runs in
Module1 and can not figure out haw to remove or reassign
this button.

Thanks
Mike


.