Replies

Thanks Charles, I’ll try a modified version of your macro. Thanks Frank

I found I could set a selection to not spell check using the set language dialog box, which has a do not check spelling tick box.

I’m using 2007 – Review tab > Proofing group > Set language

All I need do is select the bibliography and set it appropriately.
Thanks
Frank

I can’t manage a screenshot, but with two or more calendars open in he same window, the tabs with the calendar name at the top of the calendars have a horizontal button which lets you combine the view, overlapping the contents. Hope that helps. Frank

As it turns out, yes we can!
I came back to this after leaving it awhile, noticing that the ‘home’ calendar appears in the My Calendars section of the left hand side column.
From here I can open all calenders in any of the open .pst files.

I now realise I have to use Heading 1 for slide titles and Heading 2 for bullet points. My word doc started out with H2 section headings, and bullet point as, well, bullets.
It seems that you need at least one H1 for this to work – otherwise PP has no sense of where to start. Embarrasedly yours, Frank

Hello Colin,
I can see how your solution works now. I was not able to unhide all columns after using the refresh button, by (I thought) keeping the name field blank – hoping to restore the sheet to it’s original state.
I can always just close without saving of course. One useful feature is that the columns either side of the dated columns block are unaffected – I shall shortly upload a dummey example showing why this is good.

Wishing you all a happy holiday season.
Frank

Hello Catherine, thanks for this but custom views won’t do the job. They only save a pre-chozen set of show/hide columns and I need to have excel choose which ones to hide according to changing criteria.
I’m still trying with the suggestions from RG and may have time to try again over the weekend. Thanks Frank

Hello Colin and RG,
I’ve not been able to make either of your suggestions work yet, but don’t fully grok the code. I’m spending a bit of time this evening on it and will report back with news. Many thanks for all you help. Frank

Many thanks RG!

Hello Retiredgeek, this almost works – the trouble is where the range of columns is being counted. It works perfectly for Moe, as he is on holiday on day 10. For other staff, the rows up to the last AL are hidden if blank, but rows after that seem not to be selected. So for example days 3, 5, 7, 8, 9,10 remain un-hidden for Manny (with day 7 being his last AL day).

My spreadsheet has a set of columns for name, room number, extension, work team etc etc., then columns are labeled for every day of the year, cells being completed for annual leave, sick absence, study days, trips out of office and a dozen more, with a 2-letter code for each, ie AL. SK, SD and so on.

I’m looking to choose one such code, maybe SK for sick absence, then just hide all the other ‘day of the year’ columns, so I can see all the dates when that person is sick and record them for HR to have.

The column range will be the same in every case, Jan 1 is column AA and Dec 31 is (I think) OA or OB in a leap year.

This kind of thing might be really useful for a lot of people, I can think of several other applications in my job.

Many thanks again. Frank

Wow, this is so helpful, the VBA is something I will try out as well.
Many thanks Andrew and Pam!

Thanks Pam, this worked perfectly.

I spend a lot of time ‘correcting’ the direct formating applied to documents by other people, and having only the four styles which I need, normal, heading 2, bold and bullet lists, will save a lot of hunting and clicking.

I will also be able to set up templates for different kinds of documents, which may have different style-sets, so your solution is very flexible!

Thanks again
Frank

Thanks Catherine, that worked perfectly.

I did use the filename blank.potm instead of .potx assuming I needed that for the macros to work. Now the fully-themed template, with macros, opens by default just like I want it to!

Frank

Thanks to John Wilson, the VBA worked a treat.
( I am using PP 2007, should have mentioned that, and neither of retiredgeeks suggestions worked as I could not find the equivalent format commands )
But thanks to both for the input. Frank

Thanks RetiredGeek, if that’s the case I guess I have to do it all by hand? Or is there a way to remove all formating from the slides in the presentation? I’ll try that and see. Frank