how to delete a macro file

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
 
M

Myrna Larson

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.
 
A

aboiy

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
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.
 
D

Dave Peterson

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
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top