Replies

….. and it works in Footnotes as well, fantastic !

Life has just been made that little bit easier.

That seems to work fine, many thanks. I’ll try it in the book I’m currently editing. I hadn’t realised that fields could be this powerful!

Thanks, Judith, for your comments. It’s quite amazing how Word manages to let people do the things they do that “look” right ! I’ve been running over various strategies in my head as to how best to tackle these documents and decided to replace all Bold, Italics and Bold Italics with character styles to reflect them – this seems to survive quite a lot. Then to step through the paragraphs applying “Normal” to each of them. The idea is to reset the text to a default state but keep the character formatting. I can then use Word’s “Keep track of formatting” and “Highlight inconsistencies ” to correct the other weird things people do. After this re-tagging with the correct styles is easy.

TTN
Dennis

Re-styling a document is not quite a simple as I thought. After much experimenting even defining a character style as say “Italics” and that changing and italic text to that style still doesn’t always stop Word from resetting it. However after much reading up on the subject I’m beginning to devise a strategy to cope with the documents I get to “sort out” The main problem seems to be this more than 50% of a paragraphs text being something that isn’t regular when re-styled Word resets it all to regular even that tagged as “Italics” style. The sort of problems I deal with are books that have been created as “camera ready” that now need fixing because the publisher has changes the page dimensions etc., the things needs to be in pdf format as well and in both cases the books are a disaster! I’ve had footnotes that are actually “Header 1” made to look like a footnote, bits of text in a paragraph that as well as being tagged “Title” are slightly condensed. Words “keep track of formatting” and “highlight inconsistencies” are great for these type of errors. It amazes me how they got there in the first place!

Many thanks to all for your help.

TTFN
Dennis

Excellent.
I’ve only been using Styles to any great extent these past few years and this is the first time I’ve hit this problem.
I never realised that you could create a Style at character level like that – sorry Hans I realise now what you were saying. Problem sorted!

I still think it’s a bug in Word though!

Thanks very much to all….

Dennis

This sounds like a bit of a bug to me. Can see a reason for this feature!
It can be quite a problem with books where italics could be used extensively in Footnotes. I’ll need to be a lot more careful when dealing with them. Is there a way to write some sort of macro that can assess how much italics or bold there is in a paragraph? I suppose a count of each characters’ format compared to the total characters should do it.

Thanks Hans,

Dennis.

Thanks, Hans.
What a silly way for Word to behave. It always thinks it knows better !
Is there a way of stopping this ?

Dennis

Many thanks, Hans.

Sorry I should have said, I’m running Office XP Pro.
I missed the Format bit in the Protect dialogue – I’ll try that. All she needs to enter is the student names and marks I want the sheet to do the rest.

“Me” “Current Worksheet” ? Didn’t know that one.

I’m just working on the sheet putting border lines around all the cells in a rest of the row as soon as a Name is entered in the first column.

Thanks again,
Dennis.

Hi Hans
Thank you very much for this macro, it has solved something I have wanted to do for a long time which is to create a sheet that my wife ( a teacher) can easily use to enter student marks and have it automatically grade a mark she enters and keep a running total and grade. It also colours the grades so she can easily see trends. All I need to work out now is how to lock all the cells except the places where she needs to enter names and marks. If I lock them the macro complains ! I think I need to unlock the sheet at the macro start and lock it again at the end.

Magrat.

This looks interesting, thanks.
I think that I may just go down the “open this document, read what it does and click this button” route because most of the academics I deal with here do everything through Word, including opening .exe files that I’ve told them to open using “My Computer” ! I then get the phone calls – “Word’s asking me how I want to convert your program?” – Scream!

TTFN
Dennis

(It’s great being in IT support)

Sorry everyone – brain not switched on yet!
I think I need a holiday.
Yes, attached template means another file not the one I’ve attached it to. Just throw this thread away and I’ll take my embarrassment elswhere.

TTFN
Dennis.

Sorry, still doesn’t work. It always falls over in the module that has all the KeyBinding commands. I’m going to try re-writing the code to put the some of the routines I want hidden in the same module as the KeyBinding routines to see if that works.

Thanks to everyone who has offered help so far. As soon as my latest project is out of the way I’m going make to this problem. There MUST be a solution somewhere. If I every find it I’ll post the result.

TTFN
Dennis

I did a quick test but it didn’t work, I’m afraid. The Keybinding routine fell over at the line where I had changes the Sub to a Function.

I like the idea though. I never thought of using a Function instead of a Sub for things that don’t need a return. Just thinking about it though, I think most of Windows kernel calls are Functions that are often used as simple Subroutines.

I’ll do some more tests as soon as I can. It may also have something to do with the way I’ve separated the macros into different Modules that may be causing a problem.

TTFN
Dennis

Thanks for all the replies, it’s nice to know that it’s not me!

Since my template has a lot of macros in it that get bound to various key combinations I just wanted to remove them from the Macro list as there is no need to run them manually. It would also then stop the “clutter” that they make in the list so that any personal macros the staff member has created can easily be seen. I just like things tidy!

Thanks
Dennis.

Yes. The idea is that a staff member can try out my new template – I want it to do more than just change the font and margins – then if they don’t like it or feel they don’t need my “improvements” they can just delete it from the Startup folder and they’re back where they were using any changes they may have made to Normal.dot. It may be that what I am asking is just too much for Word to handle, so I may have to revert to modifying Normal.dot, maybe backing it up first, but I do feel this should be possible.