Just a place for dumping info I've learnt in IT and other stuff. My online note storage.

If you get your 2-step verification via text message it is possible, as this flaws shows, that others can redirect your calls and text messages to their phone instead. Meaning they’ll get your 2-step verification code.

Google Drive for Desktop Flaws

Putting this out there anyway, whether anyone will see this post is another thing. This is a tiny site 🙂

The number one flaw of Google Drive for Desktops when using G Suite (so in a business environment) is the lack of auditing. It states this on their support page.

  • Downloads from the following sources are not logged:
    Google Drive for Mac/PC sync client downloads

This essentially means someone in your organisation can upload loads of documents to their Google drive making sure they keep them as Office documents or other types (just not G Suite file types). They then install Google Drive for Desktop on their personal PC/Mac and connect their work account. This will then sync all their files to their personal desktop with no auditing. They can then copy all these files from their Drive share to elsewhere on their PC/Mac. They’ve now stolen lots of your data with no audit trace.

If you natively just use G Suites docs, this becomes harder for them to do, because they first need to download all the documents from a browser which automatically will convert them to Office. This means if they then try to open the Office docs, they can. If they leave them as G Suite documents they won’t be able to view them. This is because they will open in a browser and they will need to login with their work account to view them.

Worst still, if the person has left and their account disable. When they disconnect their work account on their personal PC/Mac, it doesn’t then wipe the files already sync to their Google Drive folder on the desktop. It keeps them available for them to actively copy or read.

I see that as a large flaw but then I’m no security expert, I just have an interest in it.

Kept forgetting the name of this so posting so I remember 🙂

To be clear, I only copy and paste other peoples sites sometimes in case the page I’ve linked to fails, which has happened a few times when people don’t carrying on hosting their sites.

Sometimes I blog things mostly so I can remember them and in the off chance that they might be useful to others. This post falls into that category. If you use Microsoft Excel, and you have a macro that you want to be available globally–in any open workbook–you can place it in your Personal Macro Workbook, which is just an Excel Workbook (in binary, XLSB, format, for speed) that lives at a particular location, where Excel will look for it whenever it launches.

On Windows 7, it lives here: 1


On Windows XP, it lives here:

C:\Documents and Settings\Application Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB

In either case, the easy way to create PERSONAL.XLSB is not to muck around with the file system directly. Instead, just record a macro in Excel and, when you’re prompted to save it, choose Personal Macro Workbook from the Store Macro In drop-down menu on the Record Macro dialog box. Record yourself typing a few numbers and adding some formatting to them or something similar. Afterwards, you can open up the Personal Macro Workbook via the Visual Basic button on the Developer tab later and delete whatever you record. Once you create it, your Personal Macro Workbook will be listed in the VBA Editor as “VBAProject (PERSONAL.XLSB)”.

Some Additional Details for the Truly Nerdy

The location of the Personal Macro Workbook is a little confusing, because older versions of Excel stored it in an XLSTART folder buried inside the Program Files folder. Even though you can’t write any files to it, Excel 2007 and Excel 2010 also have XLSTART folders inside the Program Files directory. Here are the paths:

For Excel 2010:

C:\Program Files\Microsoft Office\Office14\XLSTART\

For Excel 2007:

C:\Program Files\Microsoft Office\Office12\XLSTART\

“Office 14” is the internal name for Office 2010. It’s actually the 13th version of Office, but Microsoft saw fit to skip naming it Office 13, due, one suspects to superstition. So “Office 12” is Office 2007, “Office 11” is Office 2003, and so on. If you happen to be stuck running Excel 2003 on a Windows XP box, you’ll find PERSONAL.XLSB at this path:

C:\Program Files\Microsoft Office\Office11\XLSTART\




Regev – You can reset the time remaining calculations on your Paperwhite as follows:
1) Open up any book
2) Search for ;ReadingTimeReset
– include the leading semicolon, and note that it is case sensitive and there are no spaces
3) You will get 0 search results
4) Hit the back button/icon.
Your books will now show “learning reading speed”. After a bit of reading your speed, and thus time remaining, will be recalculated.

Used it once to fix an app that didn’t like UAC because it had been coded for XP.


Bad Behavior has blocked 63 access attempts in the last 7 days.