AutoUpdateFrequency failing

[wafs]

The error I'm getting is Method 'AutoUpdateFrequency' of object '_Workbook' failed. I have the ThisWindow page set up as workbook and Open, like described in the help file. Any suggestions on why it is failing.


Private Sub Workbook_Open()
ActiveWorkbook.RunAutoMacros xlAutoActivate
ActiveWorkbook.AutoUpdateFrequency = 5

End Sub

 

[xlbo]

Sounds like it may be a problemwith protection or if the workbook is not currently shared...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[wafs]

There is no protection on the workbook or worksheet and I tried to share the workbook, but share workbook under tools is greyed out.

 

[xlbo]

well 'autoupdatefrequency' is a property of a shared workbook. If the workbook is not shared, you probably can't set it.
If 'Share Workbook' is greyed out, that would imply that the workbook is protected

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[wafs]

I have it on the share drive and it still is giving me an error.

Method "AutoUpdateFrequency" of object"_workbook" failed.

Here is the code I'm using

Private Sub Workbook_Open()
ActiveWorkbook.RunAutoMacros xlAutoActivate
ActiveWorkbook.AutoUpdateFrequency = 5
ActiveWorkbook.AutoUpdateSaveChanges = True

End Sub

I went off the VB help file, did I forget something?

 

[xlbo]

no - you misunderstand. A shared workbook is not one that necessarily sits on a shared drive - it is a workbook that has been shared using Tools>Share Workbook.

If the workbook is not "shared", you cannot set this property

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question