how to delete a macro file

  • Thread starter Thread starter aboiy
  • Start date Start date
A

aboiy

Good evening to all,

I have been following one of the excel tip on merging
cell, and was referred to mcgimpsey website. When i tried
pasting some macro commands in the view code, everytime i
entered things from the worksheet it gives me a remark
of :
the macro command in this project is disable.

How will i able to remove this remarks, even i exit the
excel and start it again, it gives me the same remarks.

Also i have some macro that conflicts with the other excel
shortcut commands, if i dont want it anymore, how can i
remove or delete this things.

Any help.

aboiy
 
Do you have Tools/Macro/Security set to High? If so, all macros are disabled. Change the setting
to Medium.

To remove a macro, select the code and press the Del key, or remove the entire module (File menu
in the VBE) if you want to remove all macros in that module.
 
Myrna,

Ive tried everything you advised, but still the problem
persist. Even i exit from excel and open any file the
remarks always show whenever i press enter.

Is there anything i missed?

aboiy



-----Original Message-----
Do you have Tools/Macro/Security set to High? If so, all
Click to expand...
macros are disabled. Change the setting
to Medium.

To remove a macro, select the code and press the Del key,
Click to expand...
or remove the entire module (File menu
in the VBE) if you want to remove all macros in that module.
Click to expand...
 
You may want to look at Debra Dalgleish's site:
http://www.contextures.com/xlfaqMac.html#NoMacros
It has pictures showing what Myrna described for removing macros.

Does this really happen when open any workbook?


Myrna,

Ive tried everything you advised, but still the problem
persist. Even i exit from excel and open any file the
remarks always show whenever i press enter.

Is there anything i missed?

aboiy
-----Original Message-----
Do you have Tools/Macro/Security set to High? If so, all
Click to expand...
macros are disabled. Change the setting
to Medium.

To remove a macro, select the code and press the Del key,
Click to expand...
or remove the entire module (File menu
Click to expand...
 
Back
Top