im2bz2p345
Board Regular
- Joined
- Mar 31, 2008
- Messages
- 226
Hello all,
I have a simple macro that's in my default Excel startup file (Personal.xlsb - located in the folder C:\Documents and Settings\Username\Application Data\Microsoft\Excel\XLSTART).
The problem is when I try to open two instances of Excel (not create a new workbook). I get the error message "Personal.XLSB is locked for editing."
I've look at other threads that talk about adding the macro as an "Add-In" (http://www.mrexcel.com/forum/showthread.php?t=462524), BUT my problem is that I want to assign the macro a keyboard shoutcut (currently set to ctrl + shift + v).
Is this possible? If so, can someone walk me through it since I'm very new to add in and don't know of a way to assign an add-in macro a keyboard shortcut.
~ Im2bz2p345
I have a simple macro that's in my default Excel startup file (Personal.xlsb - located in the folder C:\Documents and Settings\Username\Application Data\Microsoft\Excel\XLSTART).
The problem is when I try to open two instances of Excel (not create a new workbook). I get the error message "Personal.XLSB is locked for editing."
I've look at other threads that talk about adding the macro as an "Add-In" (http://www.mrexcel.com/forum/showthread.php?t=462524), BUT my problem is that I want to assign the macro a keyboard shoutcut (currently set to ctrl + shift + v).
Is this possible? If so, can someone walk me through it since I'm very new to add in and don't know of a way to assign an add-in macro a keyboard shortcut.
~ Im2bz2p345