Fixed objects can move.
There are two possible solutions for this problem:
1. if you need to keep the file in Excel 97-2003 format, change the properties of the comments to move and resize with the cell. The following macro will set all comments in the workbook to move and resize with the cell:
Please make the workbook.
Bleak wb for excellent. Workbook
Set wb = ActiveWorkbook
Worksheets for each wksht
For each cmt. comment in wksh. cmt.
cmt.Shape. position = xlMoveAndSize
Next cmt.
Next wksht
2. save the workbook as Excel 2007-2010 format (XLSX, XLSM, XLSB).
Read More:
- move_uploaded_file() failed to open stream: Permission denied
- unity IOException : Failed to Move File / Directory
- [error log] 27.1.0 series of errors Error:Failed to resolve: com.android.support :support-an notations:27.1.0
- An idea to solve Warning move_uploaded_file, failed to open stream in the process of php uploading files
- Initialization order of Java objects
- “ XX.app ”It is damaged and cannot be opened. You should move it to the wastebasket.
- Form Compile Issues: (FRM-18108: Failed to load the following objects)
- django Class ‘xxx‘ has no ‘objects‘ member
- Fixed Frame [base_link] does not exist
- Python FileNotFoundError: [Errno 2] No such file or directory: ‘objects/epsilon.pkl
- Python dynamically imports objects, importlib.import_ Module() uses
- error occurred during unpacking on the remote end: unpack-objects abnormal exit
- How do I change the default background color of all FIGURE objects created in MATLAB
- ‘break’ not in the ‘loop’ or ‘switch’ context Error (Fixed)
- Git commit encountered error: pathspec (Fixed)
- Node.JS “Cannot enqueue Handshake after invoking quit” Error (Fixed)
- Remote desktop 0x104 solution?
- Authentication failed under GitHub desktop
- GitHub desktop submission errors and Solutions