Macros from a 97 xls file to a office 365 excel xlsm file, it does not seem to want to happen. Remove any characters in the Shortcut Key area. Excel displays the Macro Options dialog box. From the list of available macros, select the macro whose shortcut key you want to change. To reiterate, as simply as I can, I am merely copying existing Press Alt+F8 to display the Macro dialog box. then you suggest put it on the programming page, Why, I am not writing macros. You are very confused first telling me to use the macro recorder, why I am not writing macros. Thanks for your assistance Tina but you seem to have a problem understanding English, the macros are written already by espen haug and attached to a disk with his book in an 97 xls file, I am not trying to write anything at al merely copy and convert to the Besides, what is your operating system version? If there is any misunderstanding, please let us know. xls format and then open it, record macros and then save the workbook as. wll add-in files, and Automation Add-ins. When VBA is disabled, you can still use add-ins that are compiled, such as Excel. Open the workbook with Excel 365, save it as. Disabling VBA provides a high level of macro security because disabling VBA prevents macros from running in documents and in non-compiled add-ins such as Excel. If this is the situation, I'd like to suggest the below steps:ΔΆ. From your description, you would like to create a.
0 Comments
Leave a Reply. |