auto_open in personal.xls

[robcarr]

Hi,

i use this simple code in personal.xls when excel is opened.

Sub auto_open()
 Call RightClickMenu
 Call RightClickMenu2
 Call CreatePersonalMenu
 End Sub

this works fine when one instance of excel is open, if however I need to open another excel on the same machine, it says personal.xls is readonly, how can i get another instance to open without any popups appearing and not to save changes, as i have the coding below when excel is closed.

Sub auto_close()
    On Error GoTo errhand
    ThisWorkbook.Save
errhand:
Exit Sub
End Sub

Hope this is of use, Rob.

 

[combo]

You could transfer code to an add-in - it is easier to manage selected macros (install/uninstall add-in), moreover, if you use event procedures in ThisWorkbook module, you have more events available (Workbook_AddinInstall, Workbook_AddinUninstall).

combo

 

[robcarr]

all of the code is within personal.xls - this is a hidden workbook when excel opens.
I have saved this file as an addin in the folder and then selected it from the addins menu and all is okay, however, when it is loaded i get an excel ss called personal.xls loaded as visible, how can i get around this, so as it doesn't load a ss at all, buit i still get all the coding to use.

thanks

Hope this is of use, Rob.

 

[combo]

A workbook named 'Personal.xls' is automatically created when you choose to record macros in personal macros workbook. It is by default hidden and stored in ...\Excel\XLSTART directory, so it is opened automatically with excel. To make it hidden again, hide the window (window>hide). If you do not need it, just delete this file or move to another directory.

combo

 

[robcarr]

yeah i worked that out,

Hope this is of use, Rob.