Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

All Personal modules open in Developer

0

Help!  Everytime I open the Developer window every single module from my Personal.xlsb project opens.  It is extremely annoying.  How do I reset the Developer?  Thank you.

Answer
Discuss

Answers

0
Selected Answer

Hi again SusanUser

In the Visiual Basic Editor (aka VBA Project Explorer):

  1. click on VBAProject(PERSONAL.XLSB)
  2. right click/ choose VBAProjectProperties
  3. on the Protection tab, click "Lock project for viewing" (and enter/confirm a password- you need to remember this!)
  4. close Excel and re-open. Developer tab should now show the VBAProject(PERSONAL.XLSB) closed up and not show the codes (you need to enter that password to do that).

Although you shouldn't now see the personal macros, they will still respond (e.g. can be activated by their shortciut keys).

Reverse the process if you later want to reveal the macros.

Hope this fixes your problem. If so, please be sure to mark this Answer as Selected.

Discuss

Discussion

That worked!!  Can you tell me how they might have started to automatically open?  
Also, is there a way to save your Developer window settings, such as what windows are open (Project, Properties, Immediate, etc.) and how they are arranged?  I realize they stay the same when you close the Excel but sometimes I mess them up and then it gets annoying.

(Should I post this to a different question?)
SusanUser (rep: 18) Sep 20, '23 at 11:32 am
Glad that helped. Thanks for selecting my Answer, Susan. I've encountered that problem a coupke of times before but just cursed and sorted it manually (then closed Excel) without seeking a more reliable method.

Suggest you ask a new question- perhaps Willie knows (or I find time to try). 
John_Ru (rep: 6212) Sep 20, '23 at 12:53 pm
@John

Sorry John, but I don't have any other solution. Like yourself, I "just cursed and sorted it out manually". Now always I leave the "VBAProject" and "Properties" windows open. I may on occassion narrow the column to allow more room in the editor window but never I close them. I have also changed the font to Arial because I find it easier to read than Times New Roman. (Just have to keep in mind that the number one (1) and an upper-case " I " and a lower-case L (l) look the same)
WillieD24 (rep: 557) Sep 23, '23 at 4:23 pm
@Willie - understood, thanks for responding. I've used VBA to control the VB Editor before but not to reset/ reposition the various windows, I also use the Immediate and Locals windows for debugging so generally take care not to mess them up!
John_Ru (rep: 6212) Sep 23, '23 at 5:18 pm
Thanks @Willie and @John_Ru.  I have resorted to cursing Bill Gates and Microsoft.  
SusanUser (rep: 18) Sep 27, '23 at 12:40 pm
Hahaha! Don't blame you Susan!

I found what seems to be a plausible answer but haven't tried it (ignore the slightly misleading title)- Restore the VBE windows to their default positions using VBA in Microsoft Excel. Seems that if you delete that registry entry, VB Editor recreates it to the default window positions.
John_Ru (rep: 6212) Sep 27, '23 at 1:31 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login