Search:

Type: Posts; User: Michael Evans; Keyword(s):

Page 1 of 16 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    459

    Col A in the attached spreadsheet contains a list...

    Col A in the attached spreadsheet contains a list of birth dates given to me, Col F contains a list of dates extracted from our database. I need to match each value in Col A with a value in Col F...
  2. Replies
    4
    Views
    501

    Thank you Hans

    Thank you Hans
  3. Replies
    4
    Views
    501

    I have had XL 2003 SP3 installed on my machine at...

    I have had XL 2003 SP3 installed on my machine at work in place of XL 2000 SP3.

    Although my Personal.xls is still in XLStart, my personalised toolbars and menus have disappeared. Can I recover...
  4. Replies
    4
    Views
    431

    It seem to me that you should be using the...

    It seem to me that you should be using the Worksheet_Change event on each sheet fire your macro. Passing the Target properties to a macro in a standard module should do the trick.

    My worksheet...
  5. Replies
    4
    Views
    431

    The following code inserts a comment with time,...

    The following code inserts a comment with time, date, and cell value when a cell is changed. It works fine when the user presses Enter to enter the cell value, but if instead of pressing Enter the...
  6. Replies
    7
    Views
    709

    Re: Add a comment (XL2000 SP3)

    Thanks to everyone for your help.

    I am having trouble now in concatenating text and date whilst using the overwrite option; suppose I want to add "Cell updated on" and the date and also tell VBA...
  7. Replies
    7
    Views
    709

    Add a comment (XL2000 SP3)

    How do I detect if a cell contains a comment? I want to add a comment to the cell if it does not already contain one.

    VBA help says that the syntax for setting a comment's text is:
    ...
  8. Replies
    26
    Views
    1,237

    Re: Protecting Sheet (XL2000 SP3)

    I had not thought of this as we want the usage log to see the workbook's history, who has used it, who has altered it (I intend to add a column recording the last change made to the book, when I have...
  9. Replies
    26
    Views
    1,237

    Re: Protecting Sheet (XL2000 SP3)

    Thanks to you all for your advice.

    I tried out the book on another machine at work with the same XL version as mine and it worked (should have thought of that earlier).

    The problem was a...
  10. Replies
    26
    Views
    1,237

    Re: Protecting Sheet (XL2000 SP3)

    Hans

    I have now tried your workbook in XL2000 SP3 and it crashes at the save step there too unless I manually unprotect the sheet first.
  11. Replies
    26
    Views
    1,237

    Re: Protecting Sheet (XL2000 SP3)

    Hans

    I am at home using XL2000 SR1 and your workbook opens alright for me but crashes when I try to save it.

    Is there someone else using XL2000 who can try Hans' workbook and see if they can...
  12. Replies
    26
    Views
    1,237

    Re: Protecting Sheet (XL2000 SP3)

    Hans
    You are right of course, I had used the colon to join the Protect call with its MsgBox so they could be remarked out together, without realising VB would think it indicated a nonexistant...
  13. Replies
    26
    Views
    1,237

    Re: Protecting Sheet (XL2000 SP3)

    My theory that Protect does not work in XL2000 SP3 is wrong. Attached is my workbook with macros that Protect and Unprotect the worksheet, and they work fine as long as they are run alone. But when...
  14. Replies
    26
    Views
    1,237

    Re: Protecting Sheet (XL2000 SP3)

    Hans and Steve

    The problem arose at work where I use XL2000 SP3; at home I have XL2000 SR1 and the code works fine.

    I will not be at work again until next week but I will post the workbook...
  15. Replies
    26
    Views
    1,237

    Re: Protecting Sheet (XL2000 SP3)

    Thank you Hans

    I am not using a password so that is not the problem. What version of XL are you using? The only think I can think of is that Protect is one of those things that does not work in...
  16. Replies
    26
    Views
    1,237

    Protecting Sheet (XL2000 SP3)

    I am working on a workbook with a UsageLog sheet. The following writes the time and username when the workbook is saved. It works all right except that the lines:...
  17. Replies
    6
    Views
    678

    Re: RunTime Error 1004 (XL 2000 SP3)

    Thanks to you both
  18. Replies
    6
    Views
    678

    Re: RunTime Error 1004 (XL 2000 SP3)

    Jan

    It did not work when I first made the changes but now it seems to be doing so. I will experiment further.

    I can see a further problem though, this is to be a template and if I use...
  19. Replies
    6
    Views
    678

    Re: RunTime Error 1004 (XL 2000 SP3)

    Jan

    Thanks for your reply.

    I do not think that is the problem as I tried what you suggested and the error persists. I also made a copy of SaveWithoutSaver, stored it in the test book and used...
  20. Replies
    6
    Views
    678

    RunTime Error 1004 (XL 2000 SP3)

    I am working on a worksheet template that incorporates a user log. The following macro is supposed to enter the time of saving and who saved in columns 3 and 4, across from the last entry in column 1...
  21. Replies
    1
    Views
    461

    Personal.xls (2000 SP3)

    Does Personal.xls only work from wherever XL stores it when you create a macro as per Legare’s tutorial? I recently moved to a new machine and wanted to bring my old Personal.xls onto this, I copied...
  22. Re: Modify Buttons with VBA (XL2000 SR3)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    Thank you Hans

    I could not find a listing of FaceId's in help, however this site has them ...
  23. Modify Buttons with VBA (XL2000 SR3)

    I can add a toolbar to a workbook and add one or more buttons to the toolbar by going to Customise and dragging the yellow smiley onto the toolbar, using the macro recorder to give me code for these...
  24. Replies
    5
    Views
    548

    Re: Worksheet changes (XL 2000 SP3)

    Thanks Hans and Rudi

    Having to put the code in each sheet would be a bit of a drag, but Rudi's code works beautifully.

    Will someone explain to me what the (ByVal Sh As Object, ByVal Target As...
  25. Replies
    5
    Views
    548

    Worksheet changes (XL 2000 SP3)

    I have my UsageLog This Thread working for file opened, file saved, and username, but I cannot get it to record when changes are made anywhere in the workbook.

    I tried:

    Private Sub...
Results 1 to 25 of 387
Page 1 of 16 1 2 3 4