How come nobody seems to HELP?

HunterN · Mar 20th, 2002, 07:22 PM

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 · Mar 20th, 2002, 07:50 PM

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 TakeFocus******* property to false.

HTH,
Jay

meeh · Mar 20th, 2002, 07:53 PM

maybe the property "TakeFocus*******" 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 07:22 PM	#1
HunterN Board Regular Join Date: Mar 2002 Location: Maryland Posts: 424	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????

Mar 20th, 2002, 07:50 PM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	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 TakeFocus******* property to false. HTH, Jay

Mar 20th, 2002, 07:53 PM	#3
meeh New Member Join Date: Mar 2002 Posts: 2	maybe the property "TakeFocus*******" 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.