-
I am new to EXCEL and using 2007. I have inherited a workbook from a previous employee with drop down menus. I have created my own drop down menu, but my drop down arrow button only show when I am in the cell. The button is also to the right of the cell and outside it, but the "Help" shows...
-
Spence The file format in XL2007 is completely changed so when they are converted the whole file is stripped and rebuilt and the new format is an xml text format internally. This means that 'numbers' like 01-02 will be seen as dates during this conversion and will likely become 1-Feb in Europe...
-
First of all, hello - I am new to this forum, and this is my first post. Hopefully someone might have some insight on this. I have a scatter plot containing 12 series, originally created several years ago in Windows XP (Excel 2003?). I got a new PC two weeks ago (Vista w/Excel 2007), and after copying...
-
Dave My suggestions here are not the best I'm afraid. Moving from compatibility mode (xls to xlsx) Excel tries to approximate stuff that has changed to render it as near as possible. Colours, formatting, styles is one area where much work has gone on and I for one have had to rebuild models to make...
-
I am using 2007 excel and I am having problems opening files. When attempting to open the selected file it will try to open and just stay in limbo until I click the close icon. Now I have tried opening the same file on my laptop, which is using 2007, and it will open with no problems. This is happening...
-
Those comments are almost identical to the comments in the CMS that I use (ExpressionEngine) so that should be easy to remember. Thanks again Nick. Much appreciated. Tim
-
Nick, That makes perfect sense. I was planning to try a few callbacks later today so I'll definitely give that a shot. Do you know if it is possible to add comments to the xml in CustomUI? I can easily see me revisiting my new exam template six months from now and having to completely relearn what...
-
Nick, Excellent! Thanks for that. It works perfectly. So, how does one know when to use <commands> and when to use <menu> or <button>? SheetMoveOrCopy is listed as a button in the ExcelRibbonControls.xlsx worksheet from Microsoft. There must be some logic to this, and you seem to have...
-
Tim You need the commands attribute of the customUI (as explained in step 3), so something like... < customUI xmlns ="http://schemas.microsoft.com/office/2006/01/customui" > < commands > < command idMso ="SheetMoveOrCopy" enabled ="false" /> </ commands...
-
zfraile That's an interesting topic and sometimes you have to wonder. I can tell you though that categorically, the binary file format is optimised for speed of opening and calculation. The VB project in both file types are held in a binary format anyhow for security reasons. Certainly I've not...