ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro Ctrl Key (https://www.excelbanter.com/excel-discussion-misc-queries/149864-macro-ctrl-key.html)

Beep Beep

Macro Ctrl Key
 
I created a macro to wrap text and assigned the key of Ctrl W. I also put
this in my personal Excel file so it was available at anytime. However now I
find out the Ctrl W has been assigned by microsoft for closing a worksbook.
When I go in to change the ctrl key to a ctrl shift w it will not let me.
Not only that it won't let me delete the key.

Any suggestions.

Gwen

Macro Ctrl Key
 
Try assigning "Ctrl [shift] W" (capital W).

"Beep Beep" wrote:

I created a macro to wrap text and assigned the key of Ctrl W. I also put
this in my personal Excel file so it was available at anytime. However now I
find out the Ctrl W has been assigned by microsoft for closing a worksbook.
When I go in to change the ctrl key to a ctrl shift w it will not let me.
Not only that it won't let me delete the key.

Any suggestions.


Beep Beep

Macro Ctrl Key
 
Thanks Gwen, perfect

"gwen" wrote:

Try assigning "Ctrl [shift] W" (capital W).

"Beep Beep" wrote:

I created a macro to wrap text and assigned the key of Ctrl W. I also put
this in my personal Excel file so it was available at anytime. However now I
find out the Ctrl W has been assigned by microsoft for closing a worksbook.
When I go in to change the ctrl key to a ctrl shift w it will not let me.
Not only that it won't let me delete the key.

Any suggestions.



All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com