musicgold
04-26-2011, 12:43 PM
Hi,
Please see the attached file. This file has some dead macros which I have been trying to remove. This is just one sheet from a large file. The large file is there in my department for years.
As you will notice that there is no code module in the file and nor is there a way to view these macros. The only way to see them in Excel is by using Tools à Macro à Macros…
I want these macros out has someone as assigned the typical keyboard shortcuts to these macros and they are hampering my work style. For example, Ctr + S has been assigned to Macro 5. As a result I can’t use Ctr+S to save my work and that is very annoying. I tried to re-assign the shortcuts but it didn’t work.
I also tried the code given on this page (http://www.exceltip.com/show_tip/Modules,_Class_Modules_in_VBA/Delete_all_macros_in_a_workbook/document_using_VBA_in_Microsoft_Excel/505.html), but even it didn’t work and I got the following message: the VBProject is protected or has no components.
Is there a way to get rid of these macros or at least re-assign the shortcut keys?
Thanks.
Please see the attached file. This file has some dead macros which I have been trying to remove. This is just one sheet from a large file. The large file is there in my department for years.
As you will notice that there is no code module in the file and nor is there a way to view these macros. The only way to see them in Excel is by using Tools à Macro à Macros…
I want these macros out has someone as assigned the typical keyboard shortcuts to these macros and they are hampering my work style. For example, Ctr + S has been assigned to Macro 5. As a result I can’t use Ctr+S to save my work and that is very annoying. I tried to re-assign the shortcuts but it didn’t work.
I also tried the code given on this page (http://www.exceltip.com/show_tip/Modules,_Class_Modules_in_VBA/Delete_all_macros_in_a_workbook/document_using_VBA_in_Microsoft_Excel/505.html), but even it didn’t work and I got the following message: the VBProject is protected or has no components.
Is there a way to get rid of these macros or at least re-assign the shortcut keys?
Thanks.