|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Sorry, Excel can't open two workbooks with the same name at the same time."
I changed the Excel XLSTART folder to a different location than the default (which was C:\Users\{My username}\AppData\Roaming\Microsoft\Excel\XLSTART) , and then deleted the default XLSTART folder. However whenever I start Excel, it creates an empty XLSTART folder at the default location. This in itself doesn't cause a problem. I put a VB macro in PERSONAL.xlsb in the new XLSTART folder which adds a line to the right-click menu for all Excel workbooks. The problem occurs when I click on the added line in any workbook. I get the message "Sorry, Excel can't open two workbooks with the same name at the same time." What are the two workbooks with the same name? I have only one workbook open. I've done a search and the only PERSONAL.xlsb file found was the one in the new XLSTART folder I created. |
#2
|
|||
|
|||
I removed everything and started over again. Now the added context menu line is working as it used to. Unfortunately I have no idea why!
|
Tags |
personal.xlsb, xlstart |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro | Matt C | Excel Programming | 2 | 01-08-2022 06:03 AM |
Declare wBk as workbook. Set wBk = workbooks("NewBook.xls") gives error: Subscript out of range. | Syed Shabbir | Excel Programming | 1 | 09-27-2020 09:35 AM |
=COUNTIFS(Netc!C4:C1008,"open",Netcd!D4:D1008 ,"PC") | trevorc | Excel | 8 | 02-22-2018 11:28 AM |
ADODB import of Excel data results in "Run-time error -2147467259: <sheet> is not a valid name." | misaak | Excel Programming | 3 | 06-20-2016 07:55 AM |
"Open Recent" and "More..." in Excel and Word | BudVitoff | Office | 0 | 04-03-2015 09:17 PM |