Hi, been searching for an answer on this. probably simple or a limitation but i cant work it out 
i have a master sheet that i copy into other subsheets. the master sheet has formula's that work on new pasted dated. it all works fine.
I added some Active X Command buttons to the master sheet for filtering and when i create the subsheet the buttons get copied across but i lose the command button code in the original master sheet.
Example of master sheet code for TWO buttons are:
Private Sub CommandButton1_Click()
' command button 1 runs the hide and show trap 1 details
Application.Run "'greyhounds workings.xlsm'!Trap1show"
End Sub
Private Sub CommandButton2_Click()
'
Rows("72:119").Select
Selection.EntireRow.Hidden = True
Rows("80:87").Select
Selection.EntireRow.Hidden = False
End Sub
when i click on the button in the subsheet nothing happens.
when i then go into developer mode and view code for the button i first get any empty "GENERAL" tab. clicking on command button 1 brings up the following
Private Sub CommandButton1_Click()
End Sub
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
I have done the same for not active x buttons, being Form Control buttons and the button code IS copied across
Active X Command Button code isn't copied across. please help
driving me mad
Paul
Bookmarks