Search results for query: *

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

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...

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

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...

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

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...

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...

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...

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...

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

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...

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...

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...

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...

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

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...

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...

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

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...