Activate Sheet when workbook opens

[bigck2]

Hello,

I have a very simple piece of code. This is saved in 'ThisWorkbook':

Private Sub Workbook_Open()


    Worksheets("Home").Activate   


End Sub

Most of the time this works fine (on my machine).

However, I share this workbook with other people in my company via our company intranet - Jive.

Sometimes, depending on how the file is accessed by the user when the file is opened they may get a message saying, "Protected View - ...... Enable Editing"

If the user clicks the 'Enable Editing' button then they get the following VBA error:

"Run-time error '1004' Activate method of Worksheet class failed'.

Please let me know if you have any thoughts, on how I could get around this? I need the file to open to the 'Home" worksheet every time.

I tried doing a Workbook_BeforeClose event, but because the user doesn't really "Save" the file, they "Publish" the file to Jive this doesn't seem to work for me.

Thanks,

Chris

 

[Smitty]

The open event will generally fail when the workbook is in Protected View. Once it's enabled and reopened it should fire. Is there any way to list the Jive location as a Trusted Location?