Forum Discussion
referrall from microsoft support
The Trusted Documents quirk seems to be making its rounds lately. I believe you may get a different result on a different computer when you try to view the code in a given module. I've seen this happen before with xlsm workbooks with a lot of modules. A client I worked with had 30-40 modules and he could not view the code. I opened his workbook, could see the code so I reduced the number of modules in the workbook, and saved it under a different name and sent it back to him - he could then access the code.
I can't speak to the style of script being used in your modules because the network I'm on currently won't let me open an xlsm. Going off the screen caps posted by JKPieterse , you may want to try accessing the modules on another machine. If you can see the code, I'd try to reduce the number of modules where appropriate.
- also, I can see the macros, but I cannot edit them. I have selected enable macros, but still cannot edit them.
- I got the edit macros problem working. Thanks! I still can't see Developer>Visual Basic. This problem started when Microsoft support was trying to fix the other problem. She had control of my PC and I saw when something she did caused it to go grey, but I didn't catch what she did to cause it. Has to be some kind of setting she changed but I can't seem to find it. Any help here would be appreciated. Thanks again for your help on getting my macros back. Made I live much easier!!! I really appreciate it
Bigjim1216
