Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Activating Command Button on Workbook Being Opened

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a workbook with two worksheets "Rota" and "Message Board". The "Rota" worksheet has a command button (Comman Button1) which when clicked saves the workbook, emails it to a specified destination, inactivates the command button and displays a message box indicating that the workbook has been emailed. Is it possible to include code that will re-activate the control button 1 in the event of the worksheet being re-opened. Is it also possible to include code to close the workbook upon the OK button of the message box being clicked on?


    Many thanks


    Craig

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Keaau, Hawaii
    Posts
    238
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You use the sheet activate event to do this.
    You would paste your code there.

    Frome the VBE choose the sheet ROTA
    In the Code window select Activate from the pull down list on the right top of the window.
    Paste the code there.
    it will run when you click on the sheet tab.

    as the last line of your code put

    ThisWorkbook.Close

    The workbook will close and if there are any changes ask you if you want to save them. to avoid this write

    ThisWorkbook.Saved = True
    ThisWorkbook.Close

    The workbook will close and NOT save any changes made since the last time it was saved.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I feel the bottom line answer is:

    CommandButton1.Enabled = True

    at the Workbook_Open event ?
    Regards,

    Juan Pablo González
    http://www.juanpg.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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