Hi i was wondering if ne VBA experts can help.
I have a work sheet macro than run s off a command button to copy information from one sheet to another. the problem is the macro only works half the time. the activesheet.paste seems to generate a run time 1004 error. THe takeonfocus property of the buttons are false.
The worksheets are protected and hidden but before i paste the sheets are unhidden and unprotected. What is annoying is that it does work sometimes but not others. i don't undersatnd
Thanks for the help
I have a work sheet macro than run s off a command button to copy information from one sheet to another. the problem is the macro only works half the time. the activesheet.paste seems to generate a run time 1004 error. THe takeonfocus property of the buttons are false.
The worksheets are protected and hidden but before i paste the sheets are unhidden and unprotected. What is annoying is that it does work sometimes but not others. i don't undersatnd
Thanks for the help