Replies

Why on earth would I want to pay extra money for a facility I don’t need when I have this wonderful alternative — Set Automatic Updates to Notify.

Thanks, Jo. They were the usual bunch of Windows security updates, etc. Definitely Microsoft, and in the usual Automatic Updates screen.

Curious eh. The only thing I can think of is that some of Dell’s “helpful” software is managing things for me. I’ve checked their QuickSet utility, but it doesn’t seem to deal with this.

Maybe I’ll never know. Hopefully it won’t happen again.

I would, Hans. It just took me over my monthly megabyte limit. And what happens when Microsoft decides to automatically download 100MB of Service Pack #953 without telling me?

Has anyone got any ideas how this could happen?

But there’s a trap for young players. Go into Tools / Folder Options / View. If “remember each folder’s view settings” is on, ApplyAllFolders doesn’t seem to work.

The answer is easy, of course. Turn off “remember each folder’s view settings”.

No, it’s most definitely as I described it (p1, page break, p2, section break, p3, page break, p4). I suspect Andrew’s right and MS didn’t expect such super-duper levels of sophistication.

Thanks anyway

I have a similar objective. From a macro, I want to do the equivalent of double-clicking a particular Word template (so that an unnamed and unsaved new document opens), and I’d dearly like to avoid some of the more convoluted calculations needed when using GetObject and similar.

ActiveWorkbook.FollowHyperlink Address:= doesn’t work. It opens the template, not a document based on the template.

Anyone know an easy way of doing it?

Thanks

Hi Andy

I use a slightly different approach, with Ctrl+Shift+T setting a temporary bookmark, and Ctrl+Shift+R returning to it. I think this has all the advantages of your approach, plus it allows you to reopen a document (even the next day) and return to the point you marked when last working on the document.

I’m aware that pressing Shift+F5 on reopening a document works similarly, but using bookmarks is more resilient. For example:

• they last longer (till you next press Ctrl+Shift+T); and
• they allow you to mark a position, but do one last edit at another point in the document before closing and saving.[/list]At one point I had a more sophisticated version that worked something like this (on pressing Ctrl+Shift+T):
  • If the temporary bookmark doesn’t exist, create it.
  • If it does, offer a choice between overwriting and creating a second one.[/list]…with similar processing for Ctrl+Shift+R.

    But in the end, I decided that was too elaborate and returned to the simpler version.