part
In Excel, we can only specify a macro process for an existing program to modify the command through the FindControls (ID) method, which we may also do in Word, but if we take the second part, it is simpler This is called modifying the word command. Of course a process named mysub can be omitted and written directly in the FilePrint macro. The following is a practical example of modifying Word commands
When you use office 365 to open an excel file, an error is reported, prompting "A problem occurred while sending commands to the program", 365 excel
I bought a set of genuine office 365 and installed it on my windows 10. However, an error is reported every time an excel file is opened. They asked Microsoft technical pe
")
Activesheet.enableselection = xlUnlockedCells
End Sub
After you do this, save the settings and exit the edit window. Of course, in your own Excel, or the default of 888888 into their own password, so as not to cause leakage.
Second, the application of macros
In Excel, open the Customize command on the Tools menu, and on the Commands tab, in categories, se
Failure phenomenon:
When you open an Excel document, you are prompted to "have problems sending commands to the program" and cannot open:
Reason Analysis:This is typically due to a misuse of the settings in Excel, or Third-party software that modifies the settings in Excel.
Solution:Modify the settings to remove t
In the morning, the user reports that after the OS update is installed, the "problem occurred when sending commands to the program" error will occur when double-clicking all Excel files.
If Office2007 is reinstalled, it does not work. I searched the internet. The solution is: first run Excel2007 and open the Excel option.
Go to the "advanced" tab, remove "i
It's easy to change the file name in batches on your Windows computer. Select all the files, press F2, and then type the descriptive text.
Windows will add a unique sequence number to each file name.
This is a fairly quick solution, but not very flexible, because you can't customize the way you modify it.
For example, how do you add the current date to the filename? Or do you want to replace a few words or characters in the filename (such as a spelling error)? Or you want the file to be modif
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.