ok the problem has been sorted now.The problem was down to a third party addin, when we took the addin out of Excel it all started to work correctly again. Should have spotted this as an odditty earlier.Cheers for all the input.Steve.

<t>nope I have already tested that option and it is set to true, plus if you set it to false the dialog still comes up and prompts the user to save changes to the workbook.Thanks for the option though, I think it might be just a case of re-installing Excel and seeing what happens as it is only happe...

<t>We have a user that can load up Excel spreadsheets, make changes to it and then when they close down Excel it does not prompt them to save the changes. Does anyone know how you turn back on this warnings, or how they got turned off in the first place. I have already checked the application.displa...

<t>I am trying to copy multiple sheets from one workbook into a new workbook, but I think I have fit a another MS feature of the Software in Excel 97. I can copy multiple worksheets from one workbook into a new workbook, but only if all the selected sheets are next to each other, otherwise I get thi...

<t>Can anyone help me out here, I using Excel 97, SP2 to write a macro that copies a sheet from a workbook into a new workbook. However when I try to set the new workbook up to only have one page it crashes. It all works fine if I set the new workbook up with the default number of pages. <-CODE-> Di...

<t>sorted it now, yeah the problem is all down to the xlAutoClose event being fired too early by Excel. Microsoft seem to fire this event before the dialog box to save work appears, and we had some code in there that closed down all our DB connections, and so when the user clicked Yes to save, Excel...

<t>I have an addin that I have written for Excel that uses a XLL and I have just changed all the formulas to be non-volitile by using the # sign rather that the ! sign as the last value in the Type_text arg, however now when I quit Excel, and Excel prompts me to Save, Cancel or ??, I select Save and...

<t>Ok, I am happy writing the code in VBA land, but does anyone know how I am get the code to fire from the function Paste wizard from under by own Category option and not the default "User Defined", and will this fix my problem with Function Paste wizard then asking me for an input param.I see Micr...

<t>Does anyone know how to make Excel 97/2K behave correctly when you have a formula with no parameters.What I have is a function which returns the current NT user, so I don't want to pass any parameters into the function, but when you click on the fx button, to get the Paste Function Wizard, and se...

Ok, yeah that was my first thought was to move all the code into a VB Active X dll, but it could mean a lot of extra work and testing, where as using the Excel events (if such a thing exists) to catch when someone is in the VB IDE would be a nice and easy implementation.

<t>Does anyone know how to fire an event or tell when a user is looking at the source code to your Excel Addin?The reason for this, is that we have released a rather sensitive Addin which has the password turned on, but we want to make sure that people are not messing around with our source code, ei...

<t>Well i got it working in the end with thisExcel4(xlCoerce, &xStr, 2, xlParam, TempInt(xltypeStr));before I was being too clever, trying to copy the value out of a xloper into another one and then do the conversion, now I just do the conversion on the first one straight away. Also found out th...

<t>How do I convert an XLOPER from xltypeInt to xltypeStr? XLOPER xStr, xInt, xDestType; xInt.xltype = xltypeInt; xInt.val.num = xlParam->val.num; xDestType.xltype = xltypeInt; xDestType.val.w = xltypeStr; Excel4(xlCoerce, &xStr, 2, (LPXLOPER)&xInt, (LPXLOPER)&xDestType); Excel4(xlcAlert...

After managing to hide the formula from the function paste wizard thing (fx button), I now want to be able to hide the formula, when the user clicks on the cell, from the formula bar, and when the user double clicks on the cell the fomula is displayed.Any ideas?Steve

<t>Cheers for this, I had found this article before but never bothered to translate it.I sorted the problem out by changing one of the params for the xlfRegister to be 0 instead of 1err = Excel(xlfRegister, 0, 1+ARGCOUNT, (LPXLOPER)&xDll, (LPXLOPER)TempStr(func[0]), (LPXLOPER)TempStr(func[1]), (...