Excel macro

Tumarkin · May 18th, 2002, 08:09 PM

I have Excel file in MS Office 2000 with macro. When I generated the file I would like to remove completely macro ( to reduce size and to simlify operations with the file ). Can I do it?

Russell Hauf · May 18th, 2002, 08:13 PM

Sure! Go to the VB editor, and in the Project Explorer (show it if it's hidden), right-click on the module that holds your macro (most likely called Module1), and select remove. It will ask you if you want to export it first - you only need to do this if you want to save the macro/module by itself - if you don't need it, click No.

Hope this helps,

Russell

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 18th, 2002, 08:09 PM	#1
Tumarkin New Member Join Date: May 2002 Location: Marian Tumarkin Posts: 1	I have Excel file in MS Office 2000 with macro. When I generated the file I would like to remove completely macro ( to reduce size and to simlify operations with the file ). Can I do it?

May 18th, 2002, 08:13 PM	#2
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	Sure! Go to the VB editor, and in the Project Explorer (show it if it's hidden), right-click on the module that holds your macro (most likely called Module1), and select remove. It will ask you if you want to export it first - you only need to do this if you want to save the macro/module by itself - if you don't need it, click No. Hope this helps, Russell