Hi,
Can anyone tell me when I save my excel file to file type "Microsoft Excel Macro-Enabled Worksheet (.xlsm)" and I create a command button, and in properties (Name) it keeps changing on me every time I reopen the spreadsheet? I keep changing this in Properties and also in VBA, but somehow the properties keeps changing?
Is there anything I can do to stop this or do I need to change file type?
Can anyone tell me when I save my excel file to file type "Microsoft Excel Macro-Enabled Worksheet (.xlsm)" and I create a command button, and in properties (Name) it keeps changing on me every time I reopen the spreadsheet? I keep changing this in Properties and also in VBA, but somehow the properties keeps changing?
Is there anything I can do to stop this or do I need to change file type?