ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   don't allow users to assign the cntrl+s as a short cut for macro (https://www.excelbanter.com/excel-worksheet-functions/53852-dont-allow-users-assign-cntrl-s-short-cut-macro.html)

Sreenath

don't allow users to assign the cntrl+s as a short cut for macro
 
Hi
allowing users to have thier macro short cuts such as cntrl+s or cntrl+b is
not a good idea. as these are the frequent functions users will be using.If
the user is forgotten or not aware of the macro that exist in that excel
sheet may be mistakanly trapped and will spoil his data by using the macro
instead of the reugular functions of saving the file or changinf the font.
I was not able to find out the help topics how to revert the macro if
happens to be executed.
If I am wrong in bringing up , please correct me.
Thanks


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

JE McGimpsey

don't allow users to assign the cntrl+s as a short cut for macro
 
You're not wrong in bringing it up, but I wouldn't like this change - I
like the ability to intercept the CTRL-s keystroke to run a macro that,
perhaps, does some error checking before saving the file.

In article ,
"Sreenath" wrote:

allowing users to have thier macro short cuts such as cntrl+s or cntrl+b is
not a good idea. as these are the frequent functions users will be using.If
the user is forgotten or not aware of the macro that exist in that excel
sheet may be mistakanly trapped and will spoil his data by using the macro
instead of the reugular functions of saving the file or changinf the font.
I was not able to find out the help topics how to revert the macro if
happens to be executed.
If I am wrong in bringing up , please correct me.



All times are GMT +1. The time now is 04:42 PM.

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