+ Reply to Thread
Results 1 to 2 of 2

Macros on sheet interfering with macros on another sheet

  1. #1
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Macros on sheet interfering with macros on another sheet

    This one is for the real advanced VBA expert..I had been batteling for days now, and gave up eventually. What I am sitting with is a calculate events script on sheet 1. On the actual spreadsheet are 3 buttons that execute some things. They are called 1,2,3, respectively. Sheet 2 contains a copy of sheet 1, but the buttons here are called 4,5,6, respectively. Each sheet has a drop down menus. On both sheets, when the drop down is selected to show 1, the buttons change color to blend in with the background..(My way of hiding them)...somehow the script on sheet 1, tries to execute the script on sheet 2, but fails then because it can't find buttons 4,5 and 6 on sheet 1. I have tried tab names, code names...but the problem either continiues or some other problem creeps in..Can anyone please help me?..I am truly desperate..Sheet 1 code is as follows

    Please Login or Register  to view this content.
    The same code runs in sheet 2, but the button names are different. Thanx for your efforts with this..
    Last edited by juriemagic; 05-22-2014 at 07:02 AM.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Macros on sheet interfering with macros on another sheet

    Hard to help without seeing your code. Better still, attach your workbook.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. How to Convert Columns of Sheet 1 to Rows of Sheet 2 using Macros
    By Rintil007 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-31-2013, 10:15 AM
  2. [SOLVED] [Urgent] Inserting Time sheet Data in to Master sheet Based On the Condition Using Macros.
    By kkcmania in forum Excel Programming / VBA / Macros
    Replies: 42
    Last Post: 05-17-2013, 07:56 AM
  3. [SOLVED] Beginner Here: I need Macros to transfer specific data from one sheet to another sheet
    By aleem5 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-08-2013, 12:36 AM
  4. Development of a macros that inserts a row into sheet 1 to insert in sheet 2
    By jj123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2013, 05:24 AM
  5. Replies: 1
    Last Post: 11-11-2009, 05:54 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