Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
andreutza43 Profile
 | Femeie
25 ani
Bacau
cauta Barbat
30 - 80 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
I encountered this problem today on a Macro-Enabled file that I had open while changing my Microsoft password. I am tying the occurrence of this problem when saving with password changing, as I did not do anything else in particular with the Excel file that I didn't do since I created it 4 years ago.
The following two solutions worked for me:
1. SLOWER method:
- copied / pasted all sheets to a new file (one by one since I had Tables in each of them and Excel won't let me copy multiple sheets with tables at once)
- opened VBA and copied all code to the new file (copy / paste for all code instead of export module and import module)
or
2. EASIER/FASTER method:
- open VBA, go through all the VBA code in the problematic document and comment all lines using the special button existing for this (do not close the VBA window afterwards) - if said button does not appear, in VBA go to View - Toolbars - Edit)
- save the file (CTRL+S) - this should work without error provided that all your VBA code was "commented"
- go again through all the VBA code in the document and remove previously added comments with the specialized button (can now close VBA window)
- save the file again - this should work again without error
I also posted this message in the following topic on Microsoft website:
https://learn.microsoft.com/en-us/answe ... by=helpful
|
|
| |
|
