personal.xlsb

Need my Personal.xlsb saved on my network drive as we are required to use network drives for all files. I tried moving my file but it does not show up under View Macros. Is this possible?

Hello, I have two macros in my PERSONAL.xlsb, that does some formating and stuff to opened .csv file and autoclose it to certain location. However, since i started to operate with multiple files so i would like to ask if someone has some macro that does 1.) open file 2.) run macro (which in my...

Hi, My Personal.xlsb file was working absolutely fine yesterday, now today it doesn't automatically open when opening Excel although it's in my xlstart folder and when I try to manually open it, it brings up a Can't find project or library error message and then crashes. I've tried to locate...

When I first decided to use a personal.xlsb with Excel 2016 in XLSTART to store my macro it would load before I opened the workbook I wanted to work on so it was hidden and the workbook I needed to work on loaded last and so it was active. Fine. Recently, behavior has changed and now...

Personal.xlsb contains code only, and no visible worksheets. Can I do that with another workbook? Here's why I want to. I developed a set of macros that replicate the old F4 function of repeating a custom search. I may want to share the code, and recommend that the code be placed in...

I am using a personal.xlsb and load it every time I run my project. I activate the macros by using cntrl-shift+letter. I have already more than 26 macros connected with the specific project. How can I write more new macros? And run them from the same personal.xlsb?

I recently upgraded to Windows 10 and the installation overwrote my old personal.xlsb file erasing all the macros I had stored there. Additionally, when I start Excel now the personal.xlsb file does not open. When I go to the XLSTART folder, the file is there. I open it from the XLSTART...

It's complicated, but in summary, my corporate IT department has restricted my access to the XLSTART folder for my Personal.XLSB file using very restrictive group policies. I have all my macros backed up - but I can no longer access them from within Excel 2016. I also don't have the ability to...

Hi We switched to MS Office 2016 a few months ago and I've noticed Excel opens each file in an individual session instead of multiple files in one session. No big deal except Window Explorer is the easiest way for me to open files and when a file is opened this way, it does not share the...

My company want to upgrade CPU, will that affect the macros that stored in PERSONAL.XLSB ? Will I have to re-record the macro again ? If there is upgrade of Excel version, will there be any compatibility issues ? What other things I need to take care for the changes ? Hopefully, the...

Hi, My company has Office 365 E5 subscriptions for all it's staff, but as this is a recent thing only a few people have so far been given access to obtain the latest updates from Microsoft. I'm in this small group, but believe I'm the only one who uses Excel extensively, including the use of a...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I have a macro in my personal.xlsb that opens a file. I’m trying to change the behavior of the Workbook_Open code in the workbook being opened. I have code in my personal.xlsb...

In EXCEL 2010, my personal.xlsb does not automatically load/open if I open an EXCEL file by double clicking an .XLSX file from Windows Explorer. if I open EXCEL from the Start menu then it does automatically open the Personal.xlsb file. Why does this happen and how can I fix this? TIA Bill

Hello, The Personal.xlsb Macro file on my system is set to open automatically when Excel Opens (in the XLSTART folder) and is hidden from view, so that it is accessible for me to code and write to without having to manually open it. Normally, this is not an issue, but it has been an on again /...

I am using W10 and excel 365 home subscription I created an excel vba module in a workbook, A, and tested it out. I could test it out in debug, but had no idea how to make the spreadsheet ="see" the code module. I then wanted to move the module into personal.xlsb as I could use this code in...

I use two different PC computers at work and need to save my Excel macros on my H: drive, and point both computers to the H: drive location. Currently, only one computer can access them. I think the macros store as PERSONAL.XLSB I'm using Excel 2016 on both computers. Any help is much...

To my complete surprise, Excel seems to have stopped reading the personal.xlsb at startup, giving me a dreadful " Oh ****" shock when I went to use a macro and found that there were non showing when I clicked on "macros" in the ribbon. I have found that if I manually open...

This code works in the local Workbook perfectly, but I can not figure out how (and I tried a couple of suggestions here on S.O.F.) to get it to work in the Personal.xlsb file. Any help is much appreciated. 'This macro works locally - need to get it to work at the Personal.xlsb level Sub...

Hi all, I am hoping one of the gurus can step in and explain something which I cannot get my head around. I have been helping a fellow user to automate the selecting of all visible sheets in a workbook and piping them out as a PDF in another thread here...

I have a few macros saved into my Personal.xlsb file which work as expected. The problem is that when i close Excel and look in Task Manager there is still at least one Excel.exe running which gradually builds up in memory until it causes the whole system to slow down. Having googled around I...