Replies

As you already know – pride of place in the Places bar is taken up by Microsoft’s useless directories. If you want to change that, then assign a few directories of your own and merge the attachment into the registry (remove the .txt extension, right click and choose ‘merge’). It sets all the standard directories to ‘not show’

All standard ‘don’t sue me’ warnings apply to modifying the registry

Thanks Stuart – that’s what I thought should be happening – it means I have a little more digging to do.

No I’m not sure – but on the other hand I was testing this as a domain administrator and had set all users to have fairly serious rights such as author as well s don’t think that is likely.

My first question is – would you expect it to keep individual read attributes for each user?

I’m struggling with understanding the specific request
As I read it, the form displays at open – you want it to never display again until you exit / close the document but are happy that it displays again tomorrow?
Where I’m confused is that you appear to never want it to display again ever (tomorrow, next year …) by stating “only display the form once”?

If the first is true, then a VBA variable is perfectly fine
If the second, I cannot see a way around either document properties, or some clever ‘invisible’ marker within the file – e.g. a bookmark, a special style, an invisible graphic element …

My version of XP Home seems to be convinced otherwise – either in cmd or via run

tasklist doesn’t seem to exist in XP Home – and I cannot find it on the distribution disk either

Have you considered writing down the rows, setting text as vertical, and tipping your monitor on its side?

Hans
Has always – thanks very much. Again – your expertise shines through.
Andrew

Thanks Charlotte – it is always so easy when explained by an expert

Hans Thanks for the reference – I’ll have a play but on a first read it looks just right
Andrew

… and then there is the ‘record a macro’ method (the stuff below is from memory – so adapt as required)

Position in the first cell
Turn on Macro record and assign to a key combination,
Press {Tab} to get to last cell
Press {Right}{Left} to get to last character in cell
Type your text
Press {Tab} to position in first cell of next row.
Stop Macro recording

and run it a lot of times by pressing your key combination
Dirty – but it often works better than more complex methods.

Even absoluted cells would not handle dragging around in the weay that you describe

I think your issue relates to preventing sheet dragging – rather than absoluting the formulae.

I use Outlook to catch mail for more than one person and use mail rules to forward mail
It does require Outlook to be running for such forwarding to work.

That is, if Outlook is configured for downloading from your host, rules can then disciminate between messages and forward according to rules. If you have several addresses (1@ 2@ …) that makes the rule selection easier (because you can discriminate based on the ‘to’ address).

The rules will work fine if coded as

If 1@ then forward to real 1@ and delete and process no more rules
If 2@ ditto
If n@ ditto
Delete

The only minor problem I can see with this scheme is that all recipient addresses will see the message as having come from you, rather than the originator, and, I cannot quite understand why they do not receive their own mail directly using any one of a number of POP3 free clients.

and where is the mail going to – one machine receiving on behalf of all users, or one machine for each user?

… and the key to displaying hours in time format is to format the cell properly.

Either do the maths as Hans suggests and get decimal hours by dividing by 24 into a number field

Or use custom format and set it to [h]:mm:ss where th square brackets are required – then dividing by 24 isn’t needed.