Search:

Type: Posts; User: MartinM; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    13
    Views
    335

    I don't know an easy way to do that, but here is...

    I don't know an easy way to do that, but here is the hard way, plus some ideas !

    http://office.microsoft.com/en-gb/excel-help/find-external-references-links-in-a-workbook-HP010205611.aspx
  2. You have to dynamically name the indvidual Excel...

    You have to dynamically name the indvidual Excel tabs as Workbooks are opened/closed, using the ActiveWorkbook.Windows(n).Caption property.

    I've demonstrated to myself that it can be done manually...
  3. Maudibe, As I observed above, using the...

    Maudibe,

    As I observed above, using the ActiveWorkbook.Windows(1).Caption property is fine until you open another Excel Workbook.

    Try it, and you will see the issue - the first Workbook to be...
  4. OK, next curiosity. Using my own Workbook with...

    OK, next curiosity.

    Using my own Workbook with Application.Caption = " " the leading dash eventually disappears from the Taskbar caption without any action on my part - but it remains at the top...
  5. Well, you can get rid of the leading dash using...

    Well, you can get rid of the leading dash using the code . . .


    ActiveWorkbook.Windows(1).Caption = " "

    . . . but then, if you open another Workbook, things go sadly wrong.

    I expect there's...
  6. You can do this, but only using VBA: ...

    You can do this, but only using VBA:


    Application.Caption = ActiveWorkbook.FullName

    You have to run this line every time you open Excel, so you could, for instance, put it into an Auto_Open()...
  7. Maudibe, Your psychic powers are on turbo this...

    Maudibe,

    Your psychic powers are on turbo this evening - I was going to write just what you have written . . . taking out the line which calls up the message box is ALMOST the same as hitting...
  8. It only substitutes when you press Enter directly...

    It only substitutes when you press Enter directly after typing 2014.

    I can turn this on and off consistently with the setting mentioned above ON THIS PC but, curiously on another PC (which uses...
  9. Got it, thanks to hints from responders - thank...

    Got it, thanks to hints from responders - thank you both.

    Tools . . . AutoCorrect Options . . . AutoText tab . . . uncheck Show AutoComplete suggestions

    Job done :rolleyes:

    Phew, that's been...
  10. How to stop Word converting year (2014) to whole date format?

    When I type 2014 then hit [Return], Word 2003 turns it into 2014-11-02.

    I have tried, and failed to find the setting which controls this functionality.

    Help, please.
  11. Replies
    5
    Views
    200

    Yes, you can. Instead of using the...

    Yes, you can.

    Instead of using the "conditioned cell colour", you will find it far easier (to write and to debug) the VBA you need if you set the tab colour using the same test that the...
  12. Thread: Icon spacing

    by MartinM
    Replies
    7
    Views
    750

    Thanks for the prompt replies. Refresh changed...

    Thanks for the prompt replies.

    Refresh changed the icon size but not the spacing - it needed a reboot to do that.

    Cheers.
  13. Thread: Icon spacing

    by MartinM
    Replies
    7
    Views
    750

    Icon spacing

    XP SP3

    I am trying to get my desktop icons a little closer together.

    I can make them larger or smaller (Desktop, Properties, Appearance, Advanced . . . then Icon), but changing the Icon spacing...
  14. Thread: Debugging code

    by MartinM
    Replies
    16
    Views
    593

    Ho ho Alexandra ! I hope you don't mind a...

    Ho ho Alexandra !

    I hope you don't mind a serious answer to your lovely humour ?

    There's a balance in everything.

    You could spend months writing perfect code - logical examination of every...
  15. Thread: Debugging code

    by MartinM
    Replies
    16
    Views
    593

    It is difficult to answer your specific question...

    It is difficult to answer your specific question with any precision because there are so many possible circumstances !

    Code which is written in clearly logical sections, each performing a defined...
  16. Thread: Debugging code

    by MartinM
    Replies
    16
    Views
    593

    I presume you have tried single-stepping through...

    I presume you have tried single-stepping through the code ?

    This can be a pain when there are long loops, but its one of many techniques to work out what is happening as the code executes.
  17. Replies
    8
    Views
    237

    In the cell format dialog select Left (Indent)...

    In the cell format dialog select Left (Indent) and in the Indent: box choose how far from the left you want the characters to be.
  18. Replies
    8
    Views
    237

    Can't you simply left-align the cells ?

    Can't you simply left-align the cells ?
  19. Replies
    3
    Views
    131

    Perfect, thanks. I find the explanations for...

    Perfect, thanks.

    I find the explanations for the number formatting quite hard to follow, but the examples mostly clear it up.
  20. Replies
    3
    Views
    131

    OK, answered my own question ! I needed...

    OK, answered my own question !

    I needed "###,#".

    So my next question is . . . where is there a comprehensive list of the possibilities for the FORMAT statement - getting the answer above took...
  21. Replies
    3
    Views
    131

    Formatting numbers with VBA

    I am trying to use a VBA FORMAT statement to display numbers with no decimal places and the comma separator.

    "00" gives me the correct display but without the commas

    "000,0" gives me the commas...
  22. Good news, thanks for posting back. Dontcha like...

    Good news, thanks for posting back.
    Dontcha like software that simply works !
  23. Replies
    10
    Views
    416

    Dear Howard, I have reviewed the many posts...

    Dear Howard,

    I have reviewed the many posts you have made concerning Excel on this and other forums and I conclude that you have a complex array of spreadsheets - linked by and containing VB...
  24. You use Companion Link - not free but very good.

    You use Companion Link - not free but very good.
  25. Replies
    4
    Views
    242

    Type outlook calendar change temperature to...

    Type

    outlook calendar change temperature to celsius

    into Google and look at the first hit
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4