Hi.
Ive made a custom ribbon and it works at is should.
But the problem that poped up is ->
The UF pulls info from range a3:a1000 on active page (correct page is "SS")
If u activate the "Data" sheet it pulls the info from that page instead.
So is there a easy code to hide/deactivate the "inmatning" button on the ribbon when the "Data" sheet is activated?
The added buttons are under "frollic" tab.
Any hints or help is appreciated
Regards Zeroaim
You must use a getVisible callback to hide the control. Or you may change your code to refer to the correct sheet all the time:
Also you have two public constants with the same name in your project.
For Each Cell In Sheets("SS").Range("A2:A1000")
Last edited by Izandol; 11-29-2013 at 05:51 AM.
Thx Izandol
The fix was simple and it feels like a "doh" moment now for me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks