![]() |
Why is my Macro delete key greyed out?
I'm trying to delete a Macro created by mistake, I used Cntrl+C which has,
unintentionally, changed my mouse function. In Tools, Macros the delete key (among others) is greyed out, so I can neither delete nor edit the Macro. |
Why is my Macro delete key greyed out?
Press <Alt<F11 to go to the VBE, and edit/delete the macro there. It will
most likely be in Module 1. There may be a Module 2 as well. If it is the only macro in the module, then click on File|Remove Module#, and answer No to the question whether you want to export the module. "rogerjcfinch" wrote: I'm trying to delete a Macro created by mistake, I used Cntrl+C which has, unintentionally, changed my mouse function. In Tools, Macros the delete key (among others) is greyed out, so I can neither delete nor edit the Macro. |
Why is my Macro delete key greyed out?
Thanks kassie, that cleared the macro but the mouse 'copy' function still
will not work on that spreadsheet. I have been into the mouse and reinforced the function but to no avail. Any thoughts? "kassie" wrote: Press <Alt<F11 to go to the VBE, and edit/delete the macro there. It will most likely be in Module 1. There may be a Module 2 as well. If it is the only macro in the module, then click on File|Remove Module#, and answer No to the question whether you want to export the module. "rogerjcfinch" wrote: I'm trying to delete a Macro created by mistake, I used Cntrl+C which has, unintentionally, changed my mouse function. In Tools, Macros the delete key (among others) is greyed out, so I can neither delete nor edit the Macro. |
Why is my Macro delete key greyed out?
Exactly what is the problem with your mouse? Not sure what you mean with
mouse copy function? Maybe describe your mouse problem in more detail. If I cannot help you, I am positive someone else will though! "rogerjcfinch" wrote: Thanks kassie, that cleared the macro but the mouse 'copy' function still will not work on that spreadsheet. I have been into the mouse and reinforced the function but to no avail. Any thoughts? "kassie" wrote: Press <Alt<F11 to go to the VBE, and edit/delete the macro there. It will most likely be in Module 1. There may be a Module 2 as well. If it is the only macro in the module, then click on File|Remove Module#, and answer No to the question whether you want to export the module. "rogerjcfinch" wrote: I'm trying to delete a Macro created by mistake, I used Cntrl+C which has, unintentionally, changed my mouse function. In Tools, Macros the delete key (among others) is greyed out, so I can neither delete nor edit the Macro. |
All times are GMT +1. The time now is 11:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com