| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How make Module remember closed status in VBE?
How can I get a workbook to reliably save the Open or Closed status of
its VBA Modules in the VBE? I use Ctrl+F6 to cycle among the Modules I'm editing, and I want some of them to not keep popping up. I've had some success making a token edit, closing the unwanted Module, and then saving the Workbook. In most cases, the Module is still closed the next time I open the Workbook and open the VBE. But in some cases this doesn't work, and there's the open Module again each time I open the Workbook. (Actually, in the instance that's annoying me right now, it's the "ThisWorkbook" object.) Excel 2000, Windows 2000 Dan Williams danwPlanet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is there a way to make graphic indicators of status | Excel Discussion (Misc queries) | |||
| How can I make the status bar to be displayed as default? | Excel Discussion (Misc queries) | |||
| How do I make the status bar bigger? | Excel Worksheet Functions | |||
| how do i make Excel 'remember' the custom formatting? | Setting up and Configuration of Excel | |||
| Make "Insert Hyperlink" remember the last location | Links and Linking in Excel | |||
Threaded Mode
