ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why is my Macro delete key greyed out? (https://www.excelbanter.com/excel-discussion-misc-queries/100605-why-my-macro-delete-key-greyed-out.html)

rogerjcfinch

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.

kassie

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.


rogerjcfinch

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.


kassie

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