To automatically set to activate Workbook1 as the default workbook on reactivate Excel

[MannStewart]

hi,

i'm no vba expert, and in the past all the problems i had i could attempt myself by Googling and if that didn't work , i'd try asking for the proper solution here.

But now I have an issue that i have no idea at all how to begin at to attempt at any code. I have to have 5 workbooks open every time for my daily work and then i have to manually run between my browser and back to Excel to input data in Workbook1 only, and this running between has gotten tiring and impractical over time for my aging eyesight with increasing manual inputs & data, i find myself having to stare harder to look for my Workbook1 at the bottom of the WINDOWS screen to reactivate Workbook1.

All i want is just to have Excel automatically always set to activate Workbook1 as the default workbook, & Maximised whenever i return from my countless manual browser trips, because every time Excel would not just lose both the focus & the maximise already written for each Workbook Open & Worksheet Activate, and primarily Excel does not know which workbook to activate when I reactivate Excel. So, i'm still wondering if there is any way to write a code for this objective, assuming it is possible ? And if yes, where exactly would the code be written to ?



Stewart

[maniacb]

You can conceivably write a public macro in your personal file that is called up with a key combination that when executed, will set your master workbook as the default / active workbook and bring it to the for-front?

[MannStewart]

well, that wouldn't be solving the original problem, because i would still have to manually look for the personal file every time i return from browsing, recreating a new but similar problem, because the personal file would have the same problem as the Workbook1 wouldn't it?

[mikerickson]

You could un-maximise the screen for Workbook 1 and for the Brower, tile them so that there is always an edge of the window peeking out and just click the windows to work between them.

[karmapala]

I think what maniacb suggest is worth to try.
In the Personal.xlsb, create a macro something like :

Please Login or Register  to view this content.

Assign a keyboard shortcut to it. For example : ctlr+w, then save it.

Next time with a condition something like this :
There are 100 opened workbooks in the taskbar while the user is browsing the internet with Firefox.
At the time the user want to comeback to work with Excel,
the user click any Excel workbook in the taskbar then ctrl+w in the keyboard...
the "default" workbook then activated.

Maybe it's not exactly you want, but at least now you don't have to:

stare harder to look for my Workbook1 at the bottom of the WINDOWS screen to reactivate Workbook1

[MannStewart]

hi Mike

that doesn't work, because i dont have to unmaximise Workbook1, every time i leave excel it minimises itself with all the other 4 workbooks, and somehow only Workbook1 disappears from minimised view leaving 4 minmised unwanted Workbooks tabs at the bottom of the WINDOWS Excel reactivate bar. I have to select any of the unwanted 4 workbooks, minimise it, then l'd be able to see minimised Workbook1 again, I dont know why. Those 4 workbooks are actually supplementary workbooks as in they were opened by Workbook1, their 'father'

[MannStewart]

hi there Karmapala,

i'll give this a go, but xlsb...why does it have to be a binary file? I mean can it be a Personal.xlsm?

[karmapala]

Hi MannStewart,

I'm sorry I don't know why the personal workbook is in xlsb format.
But my guess it's maybe to make the file size is not too big.

[MannStewart]

hi Karmapala

i have created the Personal.XLSB (for the first time), but it won't launch automatically when I start Excel. I just need to test it first after recording the macro, but it won't come out. Any idea why..?

[karmapala]

Hi MannStewart,

Excel will create for you the Personal.xlsb file if you don't have it yet.

Please try like this step :
Open your "default" workbook and your "child" workbook.
Within your "child" workbook active, in Excel developer tab, click "Record Macro".

A window something like the image below will show up :
EXCEL_2020-06-29_19-55-31.png

In the image above, I already fill the shortcut key with Ctrl+w,
and in the dropdown list of "Store macro in", I select the "Personal Macro Workbook".

Soon after you hit the "OK" button, activate your "default" workbook, then stop the macro recorder.
In the vba editor's Project Explorer, you will see a workbook named "PERSONAL.XLSB", have a look on it's module1.
You will see the recorded macro there. Save it.

NB : please don't forget to delete your manually created "personal.xlsb" file .

[MannStewart]

ok

though not the ideal i was visualising of, that's still better than my current situation.

Thanks again for your guide Karmapala, and Maniacb for the idea.

Stewart.