Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi, thank you for your question. Is this using the same excel file you sent me?
Ok...so this is about recording a macro. Please give me a moment while I try the recording here....
Hi, I successfully followed the steps in your question....
Are you supposed to saved the file as Macro-Enabled file to retain the macro?
it just says to create a button in the range C11:C12 on the sales form worksheet and assign the adddate macro button. change the button label to transfer sales data.
OK. In order for the macro to be retained, the file needs to be saved as Macro Enabled file
Please give me a moment so that I can send you the file for you to test.
Here is the completed file.....please download it using this link:http://www.filedropper.com/cooking2rev2
In that page, click on the gray button that says Download This File
The file is in XLSM file format since it contains macros...saving it as XLSX will strip the macros
okay I got it to download and tested it thank you again.