How come nobody seems to HELP?

[HunterN]

I have a workbook that has a control button
that opens another workbook. This other
workbook has forms and macro code behind it
that works when I open the workbook by itself.

This is my problem: I want the second workbook only opened when the command button is selected from the first workbook. The command button does open the second workbook but, it does not allow me to select (or move) within this workbook. It sits at the current activecell and makes all changes to that one cell. I though maybe it was the Protection issue, but I've tried that and it doesn't fix anything. Any suggestions????

 

[Jay Petrulis]

Hi,

I cannot replicate your problem. I open other workbooks with a macro and the macros in the opened files work fine. I am not sure how this problem is occurring.

Is it possible that your command button is somehow not fully releasing the focus? Possibly try setting the TakeFocusOnClick property to false.

HTH,
Jay

 

[meeh]

maybe the property "TakeFocusOnClick" for your commandbutton is set to "True." Try changing it to false to see if this helps.



just a couple of suggestions--(no offense intended)--you already posed this question in a previous post, and someone replied to that post before you posted this one...no need to repost the same question as a new thread...just continue from that one. Also, please be more patient; everyone here gives of their time and help freely. If help comes, then good; if not, then it's not good manners to complain or demand. Thank you.