I don't have a guess based on the lack of detail.

But I do agree with the others when they suggested a real application that was
created for simultaneous access. (I'm not an access/db user, though.)

Martin wrote:

Thank you both for your responses. I have tried the message box and it fails
on most of the code on my PC but at different stages on another PC.

Jim - you mentioned that developers avoid using shared workbooks. How do
you overcome the sharing problem? I am trying to build a holiday chart that
is accessible by about 50 users in 3 locations so it must be shared.

My only thought was MS Access but that is not ideal either!

Martin

"Dave Peterson" wrote:

ps. I tested using xl2003.

Martin wrote:

Hello,

I have a workbook that I need to share with around 50 users in 3 locations.
I have the following code that works on the Workbook_Activate as follows:

Private Sub Workbook_Activate()
Sheets(Array("Main Menu", "H1", "H2", "Help")).Select
Sheets("Main Menu").Activate
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
.DisplayWorkbookTabs = False
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
End With

Application.DisplayFormulaBar = False

Sheets("Main Menu").Select
Range("M5").Select

Application.CommandBars("Worksheet Menu Bar").Enabled = False
Application.CommandBars("Standard").Enabled = False
Application.CommandBars("Reviewing").Enabled = False
Application.CommandBars("Formatting").Enabled = False
Application.CommandBars("Drawing").Enabled = False
Application.CommandBars("Chart").Enabled = False
Application.CommandBars("Control Toolbox").Enabled = False

ActiveSheet.Calculate

End Sub

This works fine when the workbook is not shared. As soon as I share it the
code doesn't seem to run. I have this code available to run on a short cut
key and I can run it using the shortcut key but I just cant seem to get it to
run on the workbook_activate command once shared.

Can anyone advise how I can overcome this?

Many thanks in advance.

Martin

--

Dave Peterson


--

Dave Peterson