+ Reply to Thread
Results 1 to 1 of 1

Excluding a column from protection in VB script and to add command buttons

  1. #1
    Registered User
    Join Date
    06-07-2020
    Location
    New Zealand
    MS-Off Ver
    Office 365 Pro
    Posts
    1

    Smile Excluding a column from protection in VB script and to add command buttons

    Hi there,
    I am not familiar with VB script. Would someone be able to help me with the attached excel file?

    Attached is a calibration schedule that we use to monitor the equipment calibration schedule. I need to add some more functions to this file to make it more user-friendly.

    1. On worksheet "Calibration Schedule" Column N (from N6 to end) from the existing VB script protection and users should be able to delete entries without passwords.

    2. When users clicks on the button "Remove Equipment" on the worksheet "Calibration Schedule", it should populate a user form with a dropdown list of items in Column B and space to enter a comment example image below. The highlighted things are not required. The selected item (from row A to N) should be moved to the worksheet "NotInUse".
    Remove record.JPG

    3. When users click on the button "Return Equipment" on the worksheet "NotInUse", it should populate a user form with a dropdown list of items in Column B- example image below. The highlighted things are not required and user form name should be "Return to Service". The selected item (Row A: N) should be moved to the worksheet "Calibration Schedule".
    Return Equipment.JPG

    Any help will be appreciated.

    Thanks,
    Jo
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Validation and Command Buttons or Form Buttons
    By rededdie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-20-2019, 03:48 PM
  2. Useform Code - 12 Command Buttons dependant on other command buttons
    By darrenkaye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2013, 10:58 AM
  3. Master Command Button to call on other Command Buttons located in other Workbooks
    By MrNickRegan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2013, 07:57 PM
  4. [SOLVED] Want to just Delete Command Buttons frm a Copied Sheet excluding ALL other Shapes ?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-27-2012, 03:00 AM
  5. Code for a master command button to change the backcolor of multiple command buttons?
    By panttherm5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2012, 10:11 PM
  6. Command Buttons To Select Column Row Intersect
    By rtaylor13579 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2012, 01:04 PM
  7. Linking command buttons to option buttons
    By sealtite01 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-20-2012, 12:25 PM

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