Hi,

Can someone please help me,

I have a workbook that has been copied from a large workbook to a new
workbook, using a macro, and removing all buttons. But when I save the new
workbook and then re-open it, a macro seems to have stayed on the workbook,
but I cannot find it anywhere. I've looked under the macro section in Tools
and no macro are listed.
I have managed to find something odd on the worksheet. If I select disable
the macro when the opening, a button appears at the top of the sheet. This
button is greyed out, but if I click on the button there is a formula or
code attached to it, that shows up in the Formula Bar,
(=EMBED("Forms.CommandButton.1",""))

Does anyone know what this is and how I can delete it using a macro?

Hope someone can help,
Thanks
Best regards,
Scott

To remove all objects on your worksheets (it sounds as if you have at least
one object):

-select disable macros when you open the workbook. Then on each worksheet
do a F5, Special and select "Objects" and OK. If there are objects they
will be selected and you can just press Delete to remove them.

To remove all macros you have to open the VBE (press Ctrl-F11) and
-Delete any regular Modules listed in the Project Explorer window.
-Go to the ThisWorkbook module and each Sheet module and clear out _all_
code. (You cannot delete these special modules so all you can do is remove
any code they have).

--
Jim Rech
Excel MVP

"Scott" wrote in message
...
| Hi,
|
| Can someone please help me,
|
| I have a workbook that has been copied from a large workbook to a new
| workbook, using a macro, and removing all buttons. But when I save the new
| workbook and then re-open it, a macro seems to have stayed on the
workbook,
| but I cannot find it anywhere. I've looked under the macro section in
Tools
| and no macro are listed.
| I have managed to find something odd on the worksheet. If I select disable
| the macro when the opening, a button appears at the top of the sheet. This
| button is greyed out, but if I click on the button there is a formula or
| code attached to it, that shows up in the Formula Bar,
| (=EMBED("Forms.CommandButton.1",""))
|
| Does anyone know what this is and how I can delete it using a macro?
|
| Hope someone can help,
| Thanks
| Best regards,
| Scott
|
|

Thanks very much,

I have managed to delete all the object on the sheet using the following
code;

For Each sh In ActiveSheet.Shapes
sh.Delete
Next

But I have just one problem, there's one object that needs to stay on the
sheet, a picture (Labelled - My Logo). Is there any way I can delete all the
objects except the My Logo picture?

Hope someone can help,
Thanks
Best regards,
Scott




"Jim Rech" wrote in message
...
To remove all objects on your worksheets (it sounds as if you have at least
one object):

-select disable macros when you open the workbook. Then on each worksheet
do a F5, Special and select "Objects" and OK. If there are objects they
will be selected and you can just press Delete to remove them.

To remove all macros you have to open the VBE (press Ctrl-F11) and
-Delete any regular Modules listed in the Project Explorer window.
-Go to the ThisWorkbook module and each Sheet module and clear out _all_
code. (You cannot delete these special modules so all you can do is remove
any code they have).

--
Jim Rech
Excel MVP

"Scott" wrote in message
...
| Hi,
|
| Can someone please help me,
|
| I have a workbook that has been copied from a large workbook to a new
| workbook, using a macro, and removing all buttons. But when I save the new
| workbook and then re-open it, a macro seems to have stayed on the
workbook,
| but I cannot find it anywhere. I've looked under the macro section in
Tools
| and no macro are listed.
| I have managed to find something odd on the worksheet. If I select disable
| the macro when the opening, a button appears at the top of the sheet. This
| button is greyed out, but if I click on the button there is a formula or
| code attached to it, that shows up in the Formula Bar,
| (=EMBED("Forms.CommandButton.1",""))
|
| Does anyone know what this is and how I can delete it using a macro?
|
| Hope someone can help,
| Thanks
| Best regards,
| Scott
|
|

Maybe...

Sub a()
Dim sh As Shape
For Each sh In ActiveSheet.Shapes
If sh.Name < "Picture 1" Then ''chg to your object's name
sh.Delete
End If
Next
End Sub


--
Jim Rech
Excel MVP
"Scott" wrote in message
...
| Thanks very much,
|
| I have managed to delete all the object on the sheet using the following
| code;
|
| For Each sh In ActiveSheet.Shapes
| sh.Delete
| Next
|
| But I have just one problem, there's one object that needs to stay on the
| sheet, a picture (Labelled - My Logo). Is there any way I can delete all
the
| objects except the My Logo picture?
|
| Hope someone can help,
| Thanks
| Best regards,
| Scott
|
|
|
|
| "Jim Rech" wrote in message
| ...
| To remove all objects on your worksheets (it sounds as if you have at
least
| one object):
|
| -select disable macros when you open the workbook. Then on each worksheet
| do a F5, Special and select "Objects" and OK. If there are objects they
| will be selected and you can just press Delete to remove them.
|
| To remove all macros you have to open the VBE (press Ctrl-F11) and
| -Delete any regular Modules listed in the Project Explorer window.
| -Go to the ThisWorkbook module and each Sheet module and clear out _all_
| code. (You cannot delete these special modules so all you can do is remove
| any code they have).
|
| --
| Jim Rech
| Excel MVP
|
| "Scott" wrote in message
| ...
|| Hi,
||
|| Can someone please help me,
||
|| I have a workbook that has been copied from a large workbook to a new
|| workbook, using a macro, and removing all buttons. But when I save the
new
|| workbook and then re-open it, a macro seems to have stayed on the
| workbook,
|| but I cannot find it anywhere. I've looked under the macro section in
| Tools
|| and no macro are listed.
|| I have managed to find something odd on the worksheet. If I select
disable
|| the macro when the opening, a button appears at the top of the sheet.
This
|| button is greyed out, but if I click on the button there is a formula or
|| code attached to it, that shows up in the Formula Bar,
|| (=EMBED("Forms.CommandButton.1",""))
||
|| Does anyone know what this is and how I can delete it using a macro?
||
|| Hope someone can help,
|| Thanks
|| Best regards,
|| Scott
||
||
|
|
|