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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
pisy_rasfatata din Bucuresti
 | Femeie
23 ani
Bucuresti
cauta Barbat
23 - 55 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
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:
|
|
| pus acum 4 luni |
|