Replies

Thanks Legare, works like a charm.

It saves a lot of time. I have about 20 sheets in the workbook, and to make changes, it takes forever to unprotect then protect each sheet individually.
I added a second macro to unprotect (oSheet.Unprotect), and now I can turn off my coputer and go to bed with a smile on my face…

Good work.

Thanks Legare, works like a charm.

It saves a lot of time. I have about 20 sheets in the workbook, and to make changes, it takes forever to unprotect then protect each sheet individually.
I added a second macro to unprotect (oSheet.Unprotect), and now I can turn off my coputer and go to bed with a smile on my face…

Good work.

Thanks to all of you for your replies. Now I can’t wait for the next time I get this problem, so I can whack it !!

It sure does. Thanks a lot, Leif. It warms the heart to receive help from a perfect stranger. (Well, maybe not perfect, but you are pretty good…)
Marvellous.

Well, with a little tweaking from memory, that got me some action at the printer at least.
The command copy file.prn >lpt1 brought the printer to life with the following message: “The file cannot be copied onto itself. 0 files copied.”

Any thoughts ? I was sure there would be a way to do this under Windows without resorting to the DOS command line. I mean, in Office applications, there is always the option to print to file. I can’t find anything in the help files to show how to print the resulting file.

I am interested in the answer to the second part of the original question – can anyone tell me how to print the resulting .prn file ? I tried dragging it to the printer icon, but nothing happened. Is that how it is normally done ?

The network at the office is on a server using DHCP.
THe guys at work suggested that I give the same name to the home workgroup as the office workgroup. Sounds like a neat trick.

I don’t know what DHCP is, Leif. I will try to find out when I go in to the office in a few minutes.

Thanks Leif,
That should have been very helpful, but the instructions they give don’t pan out for me.
Point 6 is impossible for me to do (“Click the Alternate Configuration tab”) because there is no Alternate Configuration tab to click. I wonder why …

Overjoyed. I didn’t expect to get such a quick solution to this problem which has been irking me for about a year now. You guys are the gurus of the gurus.
I am completely satisfied with this now.
But, if you want to go one step further, and only if you want to (because I’m happy we got this far and it is completely functional for me, but there may be others out there who find this useful too):
When you add another term to an equation, with a subscript say, all the previous formatting gets undone.
I know I know I know, we’re getting too complicated here, and it’s really not necessary.

Thanks a million Jan and kjktoo. Wonderful job. You have really impressed me.

Jan, sometimes I have more than one place in the equation where I need a subscript or a Greek symbol.
Only the first of each seems to get processed.
Example: f_r_ + #a# + S_n_ + #b#

If I edit a second time to get the second ocurrence of each type right, the first occurrence gets undone.

Wow !!!!!!!!
What an effort !!
I pasted it into a VB module of my Personal.xls, and applied it to a custom button.
It works perfectly! Genial stuff. I am so amazed that I can’t work. I’ll have to take a few minutes off.
Thanks – great effort.

It’s not quite as easy as that unfortunately. Because the ‘min’ part is just an example, and the position of the letters to be subscripted or converted to Greek is never the same from one line to the next.
I think the solution for me would be to have a short-cut key for each of the 3 types of conversion.
One exists already. I can use Ctrl-I for converting the subscript to italics.
I need another for reducing the size of the subscript to 8,
and a third for converting font to Symbol.
With those 3 shortcuts, I could convert all I need without touching the mouse.
That’s the only way to do it when the text to convert is never in the same place.

But how can I associate a shortcut key with an existing button? The button to reduce the font size by one point is already on my tool bar, but doesn’t have an associated short-cut (I think).