disabling macro

[dennismichaud]

How to disable macros?

I deleted userform, but xcel says macro is still there
when I open excel. I opened macros and there isn't
anything there. I am new to this. Userform doesn't show
up any more. It asks if I want to enable or disable
macros now upon opening excel . Any help would be
appreciated.

 

[Guest]

Dennis,

Try going through the Tools/Macros/Visual Basic Editor menu to open up the
visual basic editor.

On the left side, all the open Excel workbooks should show up. There will
be a sub-entry for each worksheet, one called "This Workbook", and possibly
folders calld "Forms" or "Modules".

If there is a "Forms" or "Modules" folder, right-click on each sub-item and
remove them. Then go through the tabs for each of the sheets and for "This
Workbook" and delete any text you see. You have to double-click on the items
to open them.

Once you've deleted everything, close the visual basic editor and save the
workbook. Then close it and open it again and see if it still asks you about
macros.

Eric

 

[dennis]

Thanks for your help it worked.

-----Original Message-----
Dennis,

Try going through the Tools/Macros/Visual Basic Editor menu to open up the
visual basic editor.

On the left side, all the open Excel workbooks should show up. There will
be a sub-entry for each worksheet, one called "This Workbook", and possibly
folders calld "Forms" or "Modules".

If there is a "Forms" or "Modules" folder, right-click on each sub-item and
remove them. Then go through the tabs for each of the sheets and for "This
Workbook" and delete any text you see. You have to double-click on the items
to open them.

Once you've deleted everything, close the visual basic editor and save the
workbook. Then close it and open it again and see if it still asks you about
macros.

Eric


.