+ Reply to Thread
Results 1 to 4 of 4

CommandButton Active ThisWorkbook

  1. #1
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Hyderbad
    MS-Off Ver
    Excel 2003
    Posts
    122

    CommandButton Active ThisWorkbook

    Please Login or Register  to view this content.
    Above code is working fine in one sheet only, but i want make it work in complete work book (thisworkbook)

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: CommandButton Active ThisWorkbook

    Check out the workbook module events

  3. #3
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: CommandButton Active ThisWorkbook

    Are all the shapes named CommandButton1?

    Place code in ThisWorkbook code window
    It will not work in either of these
    - sheet code
    - a module like Module1

    Please Login or Register  to view this content.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  4. #4
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Hyderbad
    MS-Off Ver
    Excel 2003
    Posts
    122

    Re: CommandButton Active ThisWorkbook

    Hi...Its not working for me.

+ 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. ThisWorkbook Help
    By OcMac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2012, 05:36 PM
  2. Change Active CommandButton Color
    By zplugger in forum Excel General
    Replies: 3
    Last Post: 09-11-2012, 12:46 PM
  3. Commandbutton in userform to execute code based on a previous commandbutton choice?
    By michaeljoeyeager in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2012, 03:28 PM
  4. [SOLVED] Set Wb = ThisWorkbook
    By ATLGator in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2012, 02:10 PM
  5. intercept & cancel keystroke Events when CommandButton is active
    By dlh in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-14-2010, 03:27 PM
  6. ThisWorkbook
    By DejaVu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2006, 08:55 PM
  7. Help with ThisWorkbook
    By David in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2005, 07:05 PM
  8. [SOLVED] RE: Help with ThisWorkbook
    By K Dales in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-27-2005, 05:05 PM

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