+ Reply to Thread
Results 1 to 2 of 2

auto_open macro to save a specific column

  1. #1
    Registered User
    Join Date
    03-18-2004
    Posts
    17

    auto_open macro to save a specific column

    I am trying to find a VBA formula of the type auto_open to save a specific column on a specific worksheet. Ex: worksheet name Shift Employees. Column is B. All other cells on the worksheet page except B must still be changeable.

    The goal here is to allow input in Column B during a work session but once the workbook is changed, that column can no longer be changed.

    Kimberly

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by Kimberly
    I am trying to find a VBA formula of the type auto_open to save a specific column on a specific worksheet. Ex: worksheet name Shift Employees. Column is B. All other cells on the worksheet page except B must still be changeable.

    The goal here is to allow input in Column B during a work session but once the workbook is changed, that column can no longer be changed.

    Kimberly
    Hi,

    Something like
    Please Login or Register  to view this content.
    should help

    ---
    you can add

    , Password="Password"

    if required.
    ---
    Si fractum non sit, noli id reficere.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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