Results 1 to 1 of 1

Need a bit of code to allow only VB to cut and paste info

Threaded View

todmac Need a bit of code to allow... 07-12-2011, 02:36 PM
  1. #1
    Registered User
    Join Date
    01-12-2011
    Location
    Victoria, BC
    MS-Off Ver
    Excel 2003
    Posts
    42

    Exclamation Need a bit of code to allow only VB to cut and paste info

    Hello,
    I have a workbook that tracks vehicles in our company that are out of service for any given reason. The first sheet in the book is where users enter data as vehicles go out of service, and then again as they are fixed and go back into service.

    I have formulas that tabulate information based on this information, unfortunately users are deleting entire rows, copying and pasting, and causing me to constantly have to reformat.

    I am looking for the code to complete the following.
    1/ disable cut, copy, paste when the workbook is opened.
    2/ when a user changes the "Status" (in a drop down box) to "Completed" I want to have the entire row of information moved (have the formula copy and paste it to another sheet) to the history tab (in the first blank row).

    Can anyone help with this?
    Would be greatly appreciated.
    Thanks,
    Todd
    Last edited by todmac; 07-15-2011 at 02:04 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1