Have code that drops info from a Userform into worksheet upon CommanButton Click.
The macro crashes if a user has multiple worksheets open and accidently clicks the Comman Button with the wrong workbook active.
Anyone have code to activate workbook that contains a specific worksheet ie. worksheets("data")
Thanks for the help
Code:
worksheets("data").Range("P" & updaterow) = "X"
The macro crashes if a user has multiple worksheets open and accidently clicks the Comman Button with the wrong workbook active.
Anyone have code to activate workbook that contains a specific worksheet ie. worksheets("data")
Thanks for the help