MACRO
 

I was using a Macro on a Spreadsheet, which I have now deleted and I have no
intention of using any more in this workbook. Even though I have deleted the
Macro, every time I open the Spreadsheet, it asks enable or disable macros.
How do I stop it doing this?

Thanx

MACRO
 

You need to delete the module that contained the macro from the
project.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Becks" wrote in message
...
I was using a Macro on a Spreadsheet, which I have now deleted
and I have no
intention of using any more in this workbook. Even though I
have deleted the
Macro, every time I open the Spreadsheet, it asks enable or
disable macros.
How do I stop it doing this?

Thanx

MACRO
 

Sorry for being stupid, but can you give me an idiots guide for that?

Cheers

"Chip Pearson" wrote:

You need to delete the module that contained the macro from the
project.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Becks" wrote in message
...
I was using a Macro on a Spreadsheet, which I have now deleted
and I have no
intention of using any more in this workbook. Even though I
have deleted the
Macro, every time I open the Spreadsheet, it asks enable or
disable macros.
How do I stop it doing this?

Thanx

MACRO
 

See http://www.contextures.com/xlfaqMac.html#NoMacros for such a guide

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Becks" wrote in message
...
Sorry for being stupid, but can you give me an idiots guide for that?

Cheers

"Chip Pearson" wrote:

You need to delete the module that contained the macro from the
project.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Becks" wrote in message
...
I was using a Macro on a Spreadsheet, which I have now deleted
and I have no
intention of using any more in this workbook. Even though I
have deleted the
Macro, every time I open the Spreadsheet, it asks enable or
disable macros.
How do I stop it doing this?

Thanx

MACRO
 

Open the VBA Editor (ALT+F11), and there open the Project
Explorer (CTRL+R). Expand the Tree View control for your
workbook, and open the Modules "folder". Right-click the Modules
folder and choose Remove from the pop up menu. Click 'No' to the
"Do you want to export" prompt.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Becks" wrote in message
...
Sorry for being stupid, but can you give me an idiots guide for
that?

Cheers

"Chip Pearson" wrote:

You need to delete the module that contained the macro from
the
project.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Becks" wrote in message
...
I was using a Macro on a Spreadsheet, which I have now
deleted
and I have no
intention of using any more in this workbook. Even though I
have deleted the
Macro, every time I open the Spreadsheet, it asks enable or
disable macros.
How do I stop it doing this?

Thanx

MACRO
 

This did the trick - thanks very much!

Cheers Becks

"Chip Pearson" wrote:

Open the VBA Editor (ALT+F11), and there open the Project
Explorer (CTRL+R). Expand the Tree View control for your
workbook, and open the Modules "folder". Right-click the Modules
folder and choose Remove from the pop up menu. Click 'No' to the
"Do you want to export" prompt.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Becks" wrote in message
...
Sorry for being stupid, but can you give me an idiots guide for
that?

Cheers

"Chip Pearson" wrote:

You need to delete the module that contained the macro from
the
project.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Becks" wrote in message
...
I was using a Macro on a Spreadsheet, which I have now
deleted
and I have no
intention of using any more in this workbook. Even though I
have deleted the
Macro, every time I open the Spreadsheet, it asks enable or
disable macros.
How do I stop it doing this?

Thanx