Thanks Skip,
I added the code to adjust the margins as well and it works fine - it takes only about 4 seconds, which is what I expected.
The recorded code was taking over a minute (even after I took out all the unnecessary stuff) and the main difference I see between your code and the recorded...
I have large excel 97 spreadsheet (Many formulas, Much formatting) that I have duplicated the Main Worksheet to about 25 other worksheets in the same workbook. (This gets utilized by about 6 other users via a shortcut to a template on the network). When I made the 25 identical copies it did not...
I have successfully used hyperlinks in my excel 97 spreadsheets (to both internet URL's and to call up another spreadsheet) but I am having trouble getting it to simply take me to a named cell in another sheet in the same workbook. Is there a special protocol for the formula? Is there a better /...
Is there a form/control that allows a simple (information only) pop-up window to happen when the user enters a specific data into a cell? I am using a drop down list and one of the choices simply needs to evoke a warning to the user (then the user can escape or close it and move on).
Thanks...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.