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
The same code runs in sheet 2, but the button names are different. Thanx for your efforts with this..
Bookmarks