A place for info I've learnt in IT & stuff. (I get a little kick back from affiliate ads & links, just so you are aware)

Browsing Posts in IT Notes

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.

How to disable Group By in Windows 7

To turn off Group By completely:

  1. Open any directory in Windows Explorer.
  2. Right-click and choose Group by > (None)
  3. Press the Alt key, so that the Explorer menu bar appears and chooseToolsFolder Options.
  4. Go to the View tab and click Apply to Folders. This will apply the Group By setting to all folders.

Network icon not appearing in taskbar but shows as working in Network Connections. Just doesn’t appear to be getting an IP.

This worked


go to start ,search and type:- cmd, right click on returned cmd.exe and select “run as administrator” at the prompt type:-

net localgroup Administrators /add networkservice
press enter then type:
net localgroup Administrators /add localservice
press enter then type:
press enter and restart your computer

Open services and make sure the service is started.

Kept getting MTP USB Device failed. Works fine on my other Windows 7 machines.

Oddly, this worked (you have to run CMD as admin):

net localgroup Administrators local service /add