Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    46
    Views
    1,277

    Thanks again, RG. This file works OK. I...

    Thanks again, RG. This file works OK.

    I changed the message from "Paste operation Probited" to "... prohibited", and I noted the same differences as before between an ordinary file and this one...
  2. Replies
    46
    Views
    1,277

    That is actually what I was looking for as well;...

    That is actually what I was looking for as well; my problem is more often caused by users pasting data into Excel from outside than by cutting/copying/pasting from within Excel itself.
    ...
  3. Replies
    46
    Views
    1,277

    Yes, I guess there's no reason to prevent...

    Yes, I guess there's no reason to prevent multiple pastes via Ctrl+V outside the blocked range, and that would keep things consistent with the normal behaviour in an ordinary file.
  4. Replies
    46
    Views
    1,277

    Thanks, this works fine. The changes seem to be...

    Thanks, this works fine. The changes seem to be to do with enabling/disabling CutCopy mode (i.e., whether multiple pastes are possible)? I noted the following differences between an ordinary file and...
  5. Replies
    46
    Views
    1,277

    Yes that works now. Many thanks again for your...

    Yes that works now. Many thanks again for your help.
  6. Replies
    46
    Views
    1,277

    1. Thanks, that fixed the Ctrl+V issue. 2. I...

    1. Thanks, that fixed the Ctrl+V issue.

    2. I see the code has "CellDragAndDrop = False" in Auto-Open, and "CellDragAndDrop = True" in Workbook_Close; however, the file disables the drag-and-drop...
  7. Replies
    46
    Views
    1,277

    1. I tried it in a trusted location, and it...

    1. I tried it in a trusted location, and it worked OK with the Enter keys and with right-click, but Ctrl+V was blocked from pasting everywhere, not just in the specified cells.

    2. The file...
  8. Replies
    46
    Views
    1,277

    Thanks again, your help with this is appreciated....

    Thanks again, your help with this is appreciated.

    1. When I opened the file the first time, I got a "Protected View" warning, and when I clicked on "Enable Editing" and tried pasting, the code...
  9. Replies
    46
    Views
    1,277

    Thanks for your replies, Zeddy. That works for...

    Thanks for your replies, Zeddy. That works for me. As you say, it doesn't prevent drag/drop or autofill, but in my case, users are (hopefully) unlikely to do that. However, is there a way to specify...
  10. Replies
    46
    Views
    1,277

    Thanks for the clarification. I tried this, and...

    Thanks for the clarification. I tried this, and it works with right-click, but not with Ctrl+V or Enter. I have attached my test file FYI ... am I doing something wrong?
  11. Replies
    46
    Views
    1,277

    Thanks for your reply, RetiredGeek. However, I'm...

    Thanks for your reply, RetiredGeek. However, I'm a bit confused ... can you clarify which of the four blocks of code mentioned above I need to use, and where they go ("Worksheet Module", "Standard...
  12. Replies
    46
    Views
    1,277

    Thanks for your reply. However, I don't want to...

    Thanks for your reply. However, I don't want to disable right-click altogether, as that includes other options that I want to remain enabled (e.g., Insert Comment). I only want to disable pasting...
  13. Replies
    46
    Views
    1,277

    Disabling paste into cells

    I have a worksheet created in Excel 2010 that includes a couple of columns with data validation, but if users paste data into those columns, the data validation doesn't work (and the formatting also...
  14. Replies
    5
    Views
    470

    Thanks for your reply. Yes, that works fine.

    Thanks for your reply. Yes, that works fine.
  15. Replies
    5
    Views
    470

    Thanks for your replies. Every order record...

    Thanks for your replies. Every order record always has four corresponding notes records, so Wendell's suggestion of getting a notes date/time value from one of the four notes records for each order...
  16. Replies
    5
    Views
    470

    Grouping fields in report header

    I have Access 2010 as a front end linked to a SQL database back end. I have a report with two tables ("Orders", "Notes") joined on a common field [OrderID].

    Each record in the Orders table has...
  17. Replies
    18
    Views
    1,140

    Many thanks, I've got it working now.

    Many thanks, I've got it working now.
  18. Replies
    18
    Views
    1,140

    I tried running the macro in a new document, but...

    I tried running the macro in a new document, but nothing happened to the List Number 1-5 styles. The only thing that happened was the paragraph with the cursor in it changed to "List Paragraph" style.
  19. Replies
    18
    Views
    1,140

    Thanks, but do you mean I need to run the macro...

    Thanks, but do you mean I need to run the macro once (ever) to fix something in Word, or once each time I start Word, or once each time I apply my template with my numbered list styles in it, or once...
  20. Replies
    18
    Views
    1,140

    If the bug is so well known and has been around...

    If the bug is so well known and has been around for so long, why don't they fix it?
  21. Replies
    18
    Views
    1,140

    Thanks for your replies, Andrew. However, I'm...

    Thanks for your replies, Andrew. However, I'm afraid they are over my head. I hope the bug will be fixed.

    (I don't understand what the macro achieves or how to use it. Do I just copy the macro...
  22. Replies
    18
    Views
    1,140

    Charles, thanks for your further reply; however,...

    Charles, thanks for your further reply; however, there is no issue with numbering, which works perfectly across multiple lists in multiple levels. The only issue is the loss of the indent when the...
  23. Replies
    18
    Views
    1,140

    Thanks for your replies. However, unless I have...

    Thanks for your replies. However, unless I have misunderstood something, they do not appear to address my issue. The issue is not about multi-level outlining, it is only about losing the indent when...
  24. Replies
    18
    Views
    1,140

    Thanks for your reply. A test document is...

    Thanks for your reply. A test document is attached.
  25. Replies
    18
    Views
    1,140

    Numbered style indenting issue

    In Word 2010, I have a template with a set of styles including a group like this.

    - List Number = Numbered, Indent 0, Hanging 0.5 cm
    - List Number 2 = Numbered, Indent 0.5 cm, Hanging 0.5 cm
    -...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4