Recent content by segmentationfault

Hm, that's exactly what I did. If it is turned on when the workbook is opened, I set Excel2000IsRetarded to true and turn off this ExtendList property. Upon closing, if Excel2000IsRetarded, I simply turn the ExtendList property back on. Simple enough, no? Thanks for the help. Enjoy the star.

What a bucket of junk. I just put a Workbook_Open and Workbook_Close macro that turns this misfeature off if necessary and turns it back on upon closing if necessary.

Alright, I did Tools / Options / Edit and turned off the "Extend list formulas and formats". That solves the problem, but if does that option stick with the file or will other people have the same problem as I did before I disabled this? And what did I do to cause it, and what can I...

Yeah, it is Excel 2000. I am using lots of macros in this thing, however I'm pretty sure I did this without using macros. Do you have any idea what I did?

I have a spreadsheet with some columns that have a background color, lets say columns one and two. Columns three and four have no background, and when I put in a number or letter, the background immediately becomes the same as in columns one and two. If I set columns one and two to have no...

I've been enjoying RH8.0 as well. It isn't a revolution by any means, but it is nice getting an entire system of updated software at once. I also felt the BlueCurve fiasco was ridiculous. I like the idea of synching the menu and icons between desktops, but I personally found the look&feel to...

As a matter of fact, linux has exactly what you describe. There are a few ways of achieving your goal (as is always the case with non-Windows technology) but changing the PATH shell variable is probably the easiest. In your home directory (where your shell should open when you log in), if you...

I have a macro that generates a multiple sheet report by first deleting the existing sheets and recreating them from cumulative data. Though the sheets are deleted, their numbers are not reused when new sheets are added. As a result, I have a template, cumulative data, and (currently) Sheet87...

If it's any help at all, my understanding is that Java invisibly keeps pointers in the stack, and all objects exist at the end of these pointers in the heap. This makes the memory address of anything but primitives slightly deceptive. I'm not sure whether printing the object gives you the...

Wow, pretty nostalgic to see such an old thread come back to the top. For what it's worth, I'm now using RH7.3 and I still have not figured out how to allow a regular user to write to my Win98 partition. As people have posted, any attempts to chown on that partition fails, any attempts to chmod...

Hm, please be aware that the lines "j > 2" and "j > intPosHeaderTwo + 1" are part of the previous lines and will happily generate errors if they are left as they appear.

Sorry, I glossed over your code the first time. I thought you were running this macro when you wanted to add a sheet. Your existing code seems to sort all of the sheets into the proper order. That is a better approach. Try this code. It should work until you have more than 50 sheets in each...

Is there a way to deal with a failed Workbooks.Open without an On Error statement? For example, if the workbook is already open and changed, a dialog appears asking the user if she wants to reopen the workbook and lose the changes. If she clicks "No", the Open method throws an error...

I think the simplest solution would be to use a separate macro that is identical to your existing one except that instead of "TOTALPHYSICIAN" you have "TOTALHOSPITAL", or whatever particular name you need. Then you have a macro that inserts a new doctor sheet in alphabetical...

Now see, that's what I would have thought. Here's the problems I encountered, though. First of all, in Mozilla (1.0, YMMV with other versions) none of the existing helper apps configurations are displayed on the first sheet. No problem, I created a new type, "video/mpeg". The...