Open to Cell A1

  • First, let me say thankyou to all of you who always help.


    So with that said this is what am trying to accomplish:


    When workbook opens,
    go to worksheet "home"
    go to cell "A1"
    then
    When worksheet closes save and password protect data
    unless data is already protected, in that case skip this step.


    Don't worry as I write and do different things I will learn all this stuff!

    [SIZE=2]I should change my name to STUMBED![/SIZE]

  • Re: Open to Cell A1


    Was not sure but guessed that you would also want the sheet unprotected when the workbook was opened. If not, then you can remove that line from the code.



    Put this code in the "This Workbook" object (right click on the excell icon in the left corner of the workbook and select view code).

  • Re: Open to Cell A1


    I get a an amibuous name error for the workbook_open.


    I do have a workbook open command already being used, could this cause this?

    [SIZE=2]I should change my name to STUMBED![/SIZE]

  • Re: Open to Cell A1


    Quote from chrisxs5

    I do have a workbook open command already being used, could this cause this?


    Yes


    You can only have 1 workbook event per workbook.


    You'll need to somehow combine the codes.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!