Thread: Where did my VBA code go?
View Single Post
 
Old 07-02-2020, 04:16 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,975
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
OK. The following steps are a lot easier if you have 7-Zip but I will assume you don't have a specific zip file editor installed so this involves more steps.

Take a copy of the file and change the file extension to .zip
Open the zip file and you will see a folder structure. In the docProps folder you will find a file called app.xml
Extract that app.xml file onto your desktop and open it with a Text Editor such as Notepad.
Find the text which says <DocSecurity>0</DocSecurity> and change it to <DocSecurity>1</DocSecurity>
Save the file and close the text editor.
Copy the app.xml file you just modified back into the zip file to overwrite the existing file.
Close the zip file and rename it to end with .docm again
Now open the Word file and see if you can get to the code.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote