Multi user macro (2003)

Topic

New Reply

I have a macro which is a menu item. This is contained in an Excel document. If a user already has Excel open, other users starting Excel get a message to say the document is in use with the options of Open Read Only or Cancel.
Is there a way to suppress this message? It’s a bit confusing for users. If they don’t select Open Read Only then the menu item and macro are not available to them.

Reply | Quote

Replies

> This is contained in an Excel document

Can you provide more information? Where is this “Excel document” stored, for example?

Reply | Quote

Hi Hans, excel knows to try and load that document because it’s in the xlstart directory C:Program FilesMicrosoft OfficeOFFICE11XLSTART and it opens hidden.
I would have assumed from the message that all the workstations are trying to open the same copy but this doesn’t seem to be the case.

How would you normally create a macro to used by all excel documents and where would it be stored?

Reply | Quote

It sounds as if clicking the toolbar button tries to open a second instance of Excel. Check Tools | Options…, General tab and make sure that “Ignore other applications” is off (clear).

The standard location for code that should be available in all workbooks is the Personal.xls workbook in C:Documents and SettingsApplication DataMicrosoftExcelXLSTART. See Legare Coleman’s Personal.xls Tutorial (All).

Reply | Quote

Thanks Hans – I now have a much better understanding of Excle startup – thank you.
PS – do you ever sleep?

Reply | Quote

> do you ever sleep?

Yes, some 7 hours a night or so

Reply | Quote

Added later: Excel workbooks by default can be opened by only one user at a time. There is an option to share a workbook, but I wouldn’t recommend using that – it often leads to corruption. So you should give each user an individual copy of the workbook that contains the code.

Reply | Quote