Replies

Check the thread that I started under the Windows 2000 area about April 23rd or so. Your answer may be there. If you go the the Windows 2000 area and search for Quick View, you should find it. HTH

Ron M

Thanks Bob and Charles. I think I tend to agree with Bob — MS folks were on something when they dreamed this scheme up.
Ron M

What do you know — Cartoons — yup, that is where they were. Who would have guessed? Thanks Tom.

Ron M

Thanks folks. I was able to successfully replace the W2K normal.dot with my old one and everything seems to work so far. The one thing they don’t tell you is that it is hidden about five subfolders deep in a hidden subfolder and is not stored with the “templates” in the usual place. Just when I thought MS was beginning to get it!

Ron M

Dave thanks for the PC911 reference. I was browsing these postings because I have a new W2K machine and need to move my stuff from my old Win 98 machine to the new one. I found something on their site that explains what I have to do. Now all I have to do is “just do it”. Another success for Woody’s site!!

Ron M

Thanks folks. Looks like there might be hope for Microsoft yet.

Ron M

Thanks Dave. I have set up the shared directories on the Host computer using the file sharing facilities and they seem to set up okay. I will be copying to the W2K machine from the W98 machine. I just cannnot figure out how to make the W98 files visible on the W2K machine. That is the step I am missing, or at least am unclear about. TIA.

Ron M

Maybe I am missing something, but prior to Windows 98 SE, there was a separate Service Release 2 (SR-2) made available from Microsoft and maybe it was removed from their site when Win 98 SE came out. Anyone clarify this for me? Thanks.

Ron M

Thanks Legare . That explains a lot. I shall work with this over the weekend and hopefully, I can now get it to work the way I was hoping to.

Ron M

Thanks Legare, this one works as advertised. When I looked at where the code was, between mine and yours, there are a couple of differences. If I open the VB Editor and look at the VBA Project where the code to your WorkbookOpen macro is, it is in “this worksheet”. If I look at where the code is in my attempt, it is in a module (module 2 to be exact) that is part of the VBA Project. The two other Macros that I wrote (HIDE and UNHIDE) are in Module 1, yet they both work. Does it make a difference as to where the macro code is placed? In my humble opinion, it shouldn’t, but maybe it does???

Ron M

Hans, Legare, thanks for all the help. To answer the question of what I did…not sure if I can get it exactly, but generally…to create this thing, I used an existing spreadsheet and simply cleaned it up, took out numbers, etc. and saved it as a template. The spreadsheet/worksheet consists of two parts, a top set of rows that contain travel and schedule calculations and a lower set of rows that contains, site and location information (phone, fax, address…) and bus information in case we have to ship something. There are six columns that I need to see when I am working with the spreadsheet and also I need for reporting purposes, but the technicians don’t need these on their printouts. I built a HIDE and UNHIDE macro, bound the macros to a couple of buttons outside the print area, so I can see them, but they don’t print. These both work as required. I then used Hans’ code that he so graciously provided, designed the UserForm and tried to tie it all together. Unfortunately, for whatever reason, I can’t get the Workbook_Open macro to work when I create a new worksheet from the template. I can, however, bind the macro to a button and when the button is clicked, the macro fires and the UserForm appears. Puzzle to me???

I will try what Hans has suggested and just try this with a simple spreadsheet and see what happens.

Thanks for all your help with this.

Ron M

P.S. I am using Excel 97 SR-2 with Win98

Hans, I will try what you suggest and simply put a msgbox inside the subroutine and see what happens. Strange thing is that I can bind the macro to a button on the spreadsheet and click on the button to get the UserForm to display, but not from the Workbook_Open — go figure??

Thanks for the suggestion.

Ron M

As a VBA newby, I am still learning a lot, can you tell me how this might work. Is this something that goes into an if statement…

If NewWorkbook.Open, then…or would you have
SUB NewWorkbook_Open() instead of Sub Workbook_Open()

Thanks.

Ron M

R

Thanks for everyone’s help. I can get the UserForm to work, puts data in the right place. The one thing I cannot make work is code in the Workbook Open subroutine. I may not have it set up correctly. When I open a new workbook using the template, it doesn’t even know the code is there. Any hints or thoughts as to why this happens or doesn’t as the case may be?

Thanks to all.

Ron M

Thanks to all of you.
I shall have to sort some of this out. I like Rory’s suggestion of having the control source for the text boxes tied directly to a single cell. I have one question about this…can you also tie it to a named range, where the named range is a single cell. For example, I have a single cell that I have named “Destination”. I want the UserForm to have a text box labelled “Destination” tied to the cell named “Destination” on the worksheet. Is this possible? Thanks.

Ron M