Results 1 to 5 of 5

Insert a Active Button to all sheets with the same funcion

Threaded View

  1. #1
    Spammer
    Join Date
    06-09-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    149

    Insert a Active Button to all sheets with the same funcion

    Hi everybody,

    after I got so great support least time, I hope you can support me in this one as well.

    I have an excel file with 150 sheets. My first sheet is an overview sheet where from where I can jump to each sheet.
    Now I want to insert a similar way backwards. On each of the 150 sheets should be a Button and when I click it, I jump to the "Overview" sheet.

    My Idea was to use an Active X Button and use this code to jump:

    Private Sub CommandButton1_Click()
        ThisWorkbook.Sheets("Overview").Activate
    End Sub
    But unfortunately I can't just copy this button by copy past to all sheets because the code will be lost.

    Is there a smart way to this automatically?

    The box should have the same position, colour and function as in the example attached.
    Caption: Jump to Overview
    Backcolor: &H0000FF00&
    Left: 890
    Top: 185

    Thanks so much for your ideas.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to change font size on an Active X controll button ("Command Button")
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-08-2017, 06:12 PM
  2. Button to insert current time in active cell
    By cinci-hal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-01-2016, 12:22 PM
  3. [SOLVED] Determining which Active x button was pressed?? I have two Active X buttons that operate
    By Spreadlover in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2013, 09:40 AM
  4. Replies: 30
    Last Post: 11-06-2013, 12:43 PM
  5. Tab sequence from cell to active x button and then to a command button
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2009, 02:27 PM
  6. Replies: 1
    Last Post: 11-04-2005, 10:10 AM
  7. Replies: 2
    Last Post: 02-15-2005, 03:06 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