Macro Deletion/Removal
 

Upon opening my workbook, I get the macro warning enable/disable
dialog box.
I have gone into the "Macro" "Visual Basic Editor" and tried to
"Remove Module", but the problem is that the "Remove Module" option is
greyed out. How do I get rid of the opening dialog box? There are no
macros listed in any of "All Open Workbooks" "This Workbook" or
"contract.xls", however the first item in the editor is VBA
Project(contract.xls),with "microsoft Excel Objects" under it, and
then "Sheet 1", "Sheet 2", and "This Workbook"

If at all possible I would not like to get into actual "programming"
as I would probably not get it right. Is there a way to do it using
the options in Excel?

Thank you for your time.

Macro Deletion/Removal
 

in the VBE open the objects listed in the "Project explorer"
you may see some code windows that look empty but may contains some
spaces. for every window: select all - delete to get rid of those

then save the workbook and you should be ok again.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


(Pat Davis) wrote:

Upon opening my workbook, I get the macro warning enable/disable
dialog box.
I have gone into the "Macro" "Visual Basic Editor" and tried to
"Remove Module", but the problem is that the "Remove Module" option is
greyed out. How do I get rid of the opening dialog box? There are no
macros listed in any of "All Open Workbooks" "This Workbook" or
"contract.xls", however the first item in the editor is VBA
Project(contract.xls),with "microsoft Excel Objects" under it, and
then "Sheet 1", "Sheet 2", and "This Workbook"

If at all possible I would not like to get into actual "programming"
as I would probably not get it right. Is there a way to do it using
the options in Excel?

Thank you for your time.