Deleting Macro Short Cuts
Hi,
I am researching in documents that have Macros. Since I have no need to ever run the macro I was wondering if there is a way to disable the shortcut keys? For example I am using the find function a lot and need to use the CTRL + F shortcut however, there is a Macro assigned to that and everytime I hit it a certain page prints. Let me know if there is a way to disable all the macro's or how to find the specific Macro I want to disable and then how to delete that shortcut. Thanks |
Deleting Macro Short Cuts
If you dont want to use macros, you can disable macros from menu
ToolsMacrosSecurity. (XL 2003) For 2007: checkout Developer tab, click the Macro Security button in the Code group. If this post helps click Yes --------------- Jacob Skaria "Jamie" wrote: Hi, I am researching in documents that have Macros. Since I have no need to ever run the macro I was wondering if there is a way to disable the shortcut keys? For example I am using the find function a lot and need to use the CTRL + F shortcut however, there is a Macro assigned to that and everytime I hit it a certain page prints. Let me know if there is a way to disable all the macro's or how to find the specific Macro I want to disable and then how to delete that shortcut. Thanks |
Deleting Macro Short Cuts
I have 2007 however, I do not see the Developer tab. Can you explain exactly
how you adjust the Macro security in excel 2007. Thanks "Jacob Skaria" wrote: If you dont want to use macros, you can disable macros from menu ToolsMacrosSecurity. (XL 2003) For 2007: checkout Developer tab, click the Macro Security button in the Code group. If this post helps click Yes --------------- Jacob Skaria "Jamie" wrote: Hi, I am researching in documents that have Macros. Since I have no need to ever run the macro I was wondering if there is a way to disable the shortcut keys? For example I am using the find function a lot and need to use the CTRL + F shortcut however, there is a Macro assigned to that and everytime I hit it a certain page prints. Let me know if there is a way to disable all the macro's or how to find the specific Macro I want to disable and then how to delete that shortcut. Thanks |
Deleting Macro Short Cuts
Excel OptionPopulat'Top options for working with Excel'Check the box that
says "Show Developer Tab in the Ribbon". http://office.microsoft.com/en-us/ex...969191033.aspx If this post helps click Yes --------------- Jacob Skaria "Jamie" wrote: I have 2007 however, I do not see the Developer tab. Can you explain exactly how you adjust the Macro security in excel 2007. Thanks "Jacob Skaria" wrote: If you dont want to use macros, you can disable macros from menu ToolsMacrosSecurity. (XL 2003) For 2007: checkout Developer tab, click the Macro Security button in the Code group. If this post helps click Yes --------------- Jacob Skaria "Jamie" wrote: Hi, I am researching in documents that have Macros. Since I have no need to ever run the macro I was wondering if there is a way to disable the shortcut keys? For example I am using the find function a lot and need to use the CTRL + F shortcut however, there is a Macro assigned to that and everytime I hit it a certain page prints. Let me know if there is a way to disable all the macro's or how to find the specific Macro I want to disable and then how to delete that shortcut. Thanks |
All times are GMT +1. The time now is 10:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com