custom toolbar buttons

Jackeb · Apr 26th, 2002, 07:08 AM

I have a custom toolbar button that opens a userform

Public Sub FormReturn27()

Hide_All
mfareaval = "27A"
UnitFormS.Show

End Sub

whaere hide_all just hides all but 1 worksheet

the problem is that I get this error:

Adocument with the name "..." is already open, Your cannot open two document with the same name even if the documents are in different folders.

as far as i can tell I m not trying to open anything... just show a form...

any ideas?

Ed

Mark O'Brien · Apr 26th, 2002, 07:45 AM

I'm guessing this is a UserForm and that you have some code in the Initialize or the Activate event that has a line like:

Workbooks.Open etc etc

Even though the debugger is highlighting the .Show code line, the problem is really with your userform, not this line of code. It's sort of a quirk of the VBE debugger.

northrock · Apr 30th, 2002, 10:20 PM

I had a similar sounding problem after moving a workbook between drives. The custom toolbar had macros associated with various buttons, these had to be re-associated with the macros in the new workbook location, other wise I was given the same fault message as you are getting.

Apr 26th, 2002, 07:45 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	I'm guessing this is a UserForm and that you have some code in the Initialize or the Activate event that has a line like: Workbooks.Open etc etc Even though the debugger is highlighting the .Show code line, the problem is really with your userform, not this line of code. It's sort of a quirk of the VBE debugger. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

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

Apr 26th, 2002, 07:08 AM	#1
Jackeb Board Regular Join Date: Mar 2002 Posts: 81	I have a custom toolbar button that opens a userform Public Sub FormReturn27() Hide_All mfareaval = "27A" UnitFormS.Show End Sub whaere hide_all just hides all but 1 worksheet the problem is that I get this error: Adocument with the name "..." is already open, Your cannot open two document with the same name even if the documents are in different folders. as far as i can tell I m not trying to open anything... just show a form... any ideas? Ed

Apr 30th, 2002, 10:20 PM	#3
northrock New Member Join Date: Apr 2002 Posts: 38	I had a similar sounding problem after moving a workbook between drives. The custom toolbar had macros associated with various buttons, these had to be re-associated with the macros in the new workbook location, other wise I was given the same fault message as you are getting.