Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DuckBill

    Redirecting linked named ranges

    acron, Thanks for the idea. I saved the sheet as a file and removed the range names. But when the sheet is added into the workbook all the affected cells still say #NAME? and need to be refreshed (using F2 then Enter). I guess there is a way to do this in code...can you help? DuckBill
  2. DuckBill

    Redirecting linked named ranges

    I have a spreadsheet which is well-used within my company, and I need to get users to add in a new reporting sheet. This is fairly straightforward using Edit | Move or Copy Sheet… from a new master file that they can access. There are links to be re-directed from the Master sheet to their file...
  3. DuckBill

    Excel file opening and macros

    MiggyD, To be honest, I have never really got into Certified macros. But in this case, all the spreadsheets (and macros) were created by myself. The real question is why does my copy of Excel treat the same file differently depending solely on how it is opened? DuckBill
  4. DuckBill

    Excel file opening and macros

    dsi, Yes, I looked there too! It is currently set to "Medium" security level, which means that it should ask whether I want to enable or disable macros. As I said, it does this with files opened from the recently-used list, but not when I use File, Open. Any other ideas, anyone...
  5. DuckBill

    Excel file opening and macros

    Dale, Yes... and no! Tools - Options was the first place I looked. But there is nothing about "Macro virus protection" on the "General" tab of my copy of Excel. Also, surely any such setting ought to apply, irrespective of how a file is opened? Regards, Paul
  6. DuckBill

    Excel file opening and macros

    My PC seems to have developed a strange habit that I cannot seem to stop. I am using Excel 2000 and if I open a file from the recently-used list (under the File menu), I am prompted with the usual "Do you want to disable / enable macros" dialog box, and if I choose "enable&quot...
  7. DuckBill

    Pasting Formulas In Excel (Slightly Different)

    Mictain, xlbo's solution probably works OK (I haven't tried it), but I thought I would add my suggestion, just for the record. (It's not as elegant, but could be useful for other situations) When I have to set up a large number of sheets which are all similar, and each one links to the...
  8. DuckBill

    Outlook Read Receipt

    johannesd, In Outlook 2000 (and previous, I believe) just right-click on the field headers in your Inbox and select "Field Chooser". Scroll down the list of available fields, and you should see one called "Receipt Requested"; drag it across to wherever you want to put it in...
  9. DuckBill

    Excel combo boxes - font size

    Thanks for all the responses; all very interesting and useful. I have now replaced my Forms-created Combo Box with a Control Toolbox-created one and have been able to change the font to a better size. I did need to reconfigure some other things, however, as the new Combo Box seems to only...
  10. DuckBill

    Excel combo boxes - font size

    I am using Excel 2000 and the Combo Box is located on a worksheet (not on a form). DuckBill
  11. DuckBill

    Excel combo boxes - font size

    I have an Excel spreadsheet which uses combo boxes. The default font size used for the items displayed in the drop down list in the boxes is currently too small and I cannot find any way of changing it. Unlike other controls, there is no "Font" tab in the "properties" form...
  12. DuckBill

    Hello all, I have a spreadsheet

    tsmith, I'm glad that you found my suggestion useful. As for the printer dialog, I have not used the application.dialogs method. But when I use the code as listed and click the printpreview button, then click "print" from the preview, the printer dialog box opens anyway. So the user...
  13. DuckBill

    Hello all, I have a spreadsheet

    tsmith First of all, wbishopjr may have the neatest idea if you can set the print area appropriately; I was assuming that the cells to be hidden were in the middle of the print area so that wasn't an option. If I am right, then going back to my original suggestion of using a macro... In the...
  14. DuckBill

    Hello all, I have a spreadsheet

    tsmith, Just another suggestion; if you are having the users enter data into cells on a spreadsheet, but you don't want those cells printed out, why not create a macro to do the printing. You can then arrange that before it prints, the macro either changes the format of the cells (to white or...
  15. DuckBill

    Changing part of an array in Excel

    Thanks for the clarification. That could be a useful approach, perhaps for other purposes if not this one. Anyone got any ideas on the original problem? (Inserting rows in a spreadsheet with array formulas, see above) DuckBill
  16. DuckBill

    Changing part of an array in Excel

    Thanks for the response, MichaelRed, but I'm not sure that I fully understand it. If you are suggesting that we should have created the whole thing in a database in the first place, then that's possibly a fair comment. However, this estimating system is not used to retain any cost data; the...
  17. DuckBill

    Changing part of an array in Excel

    I have developed a large cost estimating spreadsheet for my company and am always looking for ways to reduce the size of the file it creates so that it is easier to e-mail etc. I have been looking into using array formulas on the spreadsheet itself and I believe that their use would help cut...
  18. DuckBill

    excel vba, rounding a textbox value

    If it's a cell that you are trying to change, how about: Selection.NumberFormat = "0.0000"
  19. DuckBill

    Excel Formula to Text

    If you just want to show the formula in a particular cell as text, you can always prefix it with a single inverted comma (') thus: '=1+A3 Another alternative is to put the whole formula into inverted commas thus: ="=1+A3" Both of the above will display the text =1+A3 in the...

Part and Inventory Search

Back
Top