Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
only one of 2 xlsm files shows up in vba editor
When I open up 2 macro-enabled workbooks(*.xlsm) simultaneously (highlight 2 *.xlsm files in windows explorer and hit enter), both files open but when I go to the VBA editor only one is displayed.
If I then select file not displayed in the VBA editor and try and open the VBA editor(Alt/F11), a 2nd VBA editor is opened. What's weird is that when I try this on another very similar model computer, it works normally (both files are displayed in VBA editor) To get the bad computer to work properly, I need to open 1 file first, then open the second and then both are displayed in VBA editor. Ideas? Thanks Jeff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
only one of 2 xlsm files shows up in vba editor
When I open up 2 macro-enabled workbooks(*.xlsm) simultaneously (highlight 2
*.xlsm files in windows explorer and hit enter), both files open but when I go to the VBA editor only one is displayed. If I then select file not displayed in the VBA editor and try and open the VBA editor(Alt/F11), a 2nd VBA editor is opened. What's weird is that when I try this on another very similar model computer, it works normally (both files are displayed in VBA editor) To get the bad computer to work properly, I need to open 1 file first, then open the second and then both are displayed in VBA editor. Ideas? Thanks Jeff What version of Excel? What version of Windows? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
only one of 2 xlsm files shows up in vba editor
When I open up 2 macro-enabled workbooks(*.xlsm) simultaneously (highlight
2 *.xlsm files in windows explorer and hit enter), both files open but when I go to the VBA editor only one is displayed. If I then select file not displayed in the VBA editor and try and open the VBA editor(Alt/F11), a 2nd VBA editor is opened. What's weird is that when I try this on another very similar model computer, it works normally (both files are displayed in VBA editor) To get the bad computer to work properly, I need to open 1 file first, then open the second and then both are displayed in VBA editor. Ideas? Thanks Jeff What version of Excel? What version of Windows? Not sure this makes any diff but I use the checkbox option in WE; - all selected files that are checked open and show in same instance of Excel and same VBE, as expected. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
only one of 2 xlsm files shows up in vba editor
On Tuesday, September 3, 2019 at 10:40:52 AM UTC-7, GS wrote:
When I open up 2 macro-enabled workbooks(*.xlsm) simultaneously (highlight 2 *.xlsm files in windows explorer and hit enter), both files open but when I go to the VBA editor only one is displayed. If I then select file not displayed in the VBA editor and try and open the VBA editor(Alt/F11), a 2nd VBA editor is opened. What's weird is that when I try this on another very similar model computer, it works normally (both files are displayed in VBA editor) To get the bad computer to work properly, I need to open 1 file first, then open the second and then both are displayed in VBA editor. Ideas? Thanks Jeff What version of Excel? What version of Windows? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion Office 365 ProPlus. Windows 10. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
only one of 2 xlsm files shows up in vba editor
On Tuesday, September 3, 2019 at 11:02:15 AM UTC-7, GS wrote:
When I open up 2 macro-enabled workbooks(*.xlsm) simultaneously (highlight 2 *.xlsm files in windows explorer and hit enter), both files open but when I go to the VBA editor only one is displayed. If I then select file not displayed in the VBA editor and try and open the VBA editor(Alt/F11), a 2nd VBA editor is opened. What's weird is that when I try this on another very similar model computer, it works normally (both files are displayed in VBA editor) To get the bad computer to work properly, I need to open 1 file first, then open the second and then both are displayed in VBA editor. Ideas? Thanks Jeff What version of Excel? What version of Windows? Not sure this makes any diff but I use the checkbox option in WE; - all selected files that are checked open and show in same instance of Excel and same VBE, as expected. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion Checkbox Option in Windows Explorer? Sorry, not sure about that method/option. I just highlight both xlsm files in WE and hit enter. Thanks Jeff |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
only one of 2 xlsm files shows up in vba editor
On Tuesday, September 3, 2019 at 10:40:52 AM UTC-7, GS wrote:
When I open up 2 macro-enabled workbooks(*.xlsm) simultaneously (highlight 2 *.xlsm files in windows explorer and hit enter), both files open but when I go to the VBA editor only one is displayed. If I then select file not displayed in the VBA editor and try and open the VBA editor(Alt/F11), a 2nd VBA editor is opened. What's weird is that when I try this on another very similar model computer, it works normally (both files are displayed in VBA editor) To get the bad computer to work properly, I need to open 1 file first, then open the second and then both are displayed in VBA editor. Ideas? Thanks Jeff What version of Excel? What version of Windows? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion Office 365 ProPlus. Windows 10. Ok, using Win7 + Office 365 Personal is working; - I'll try a Win10 machine and report back! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xlsm.zip files do not show as folders in Explorer | Excel Programming | |||
Copy and replace xlsm files, but retain the values in selected cells... | Excel Discussion (Misc queries) | |||
Excel 2007 tmp files filling up drive with XLSM files | Excel Worksheet Functions | |||
Is there a Folder Picker method that shows files too? | Excel Programming | |||
Sheet shows macros embedded but none are in VB editor | Excel Programming |