+ Reply to Thread
Results 1 to 4 of 4

Macro Button -different sheets to be moved to Dashboard front page

  1. #1
    Registered User
    Join Date
    07-26-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    36

    Macro Button -different sheets to be moved to Dashboard front page

    Dear All

    I have 3 sheets and 3 macro buttons on each sheets. What i would like to do is create front sheet (Dashboard) and move the macro button to the front page and be able to still run the data etc and get the results on each sheets. I can move the macro buttons, but it shows me a debug in the end. Kindly help if there is a quick fix?

    Regards
    Last edited by RAJRAJ85; 11-18-2017 at 07:13 PM.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Macro Button -different sheets to be moved to Dashboard front page

    That will be kinda difficult without seeing your workbook and current codes used.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Registered User
    Join Date
    07-26-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    36

    Re: Macro Button -different sheets to be moved to Dashboard front page

    Hey Bakerman,

    I have managed to put all on a single sheet. Will this be easy enough now? My sheets name are

    Dashboard
    Data

    Please advise

    Regards

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Macro Button -different sheets to be moved to Dashboard front page

    What I meant was to post an example workbook with some data and the codes you are now using.

+ 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. Stop macro from moving to front page on save
    By EuEra in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2014, 02:03 AM
  2. Problem with macro/vba - Want to bring page to front?
    By Wanting2Excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2013, 06:24 PM
  3. [SOLVED] Button which links the front page to another page depending on a data validation cell valu
    By greg19 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-12-2013, 03:59 AM
  4. [SOLVED] Issue with assigning a macro to a button after the sheet is moved.
    By UsmanBPD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2012, 10:44 AM
  5. MS Word Footer Macro Different Front page
    By J.wills in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2009, 05:09 AM
  6. [SOLVED] Sheets Tabs moved to Right Side of Page. How to get back to Left ?
    By Corey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-07-2006, 12:00 AM

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