| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
| Can T Get Macro To Run! | New Users to Excel | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| Date macro | Excel Discussion (Misc queries) | |||
Hybrid Mode
