Visual Basic in a shared workbook

[Rodels]

Hi everyone,
I have written some rather complex code to be used in a shared workbook that
can be updated by multiple users.

All works fine until I share the Workbook..

I am getting 1004 errors but can't access the code to debug it as the VBA is
unavailable in a shared workbook.

I don't really have a question other than - how can I debug that which I
can't see?

Kind regards,
Robert
--
Kind regards,
Robert


Rodels! Creating weapons of Maths Destruction since 2003.

 

[Dave Peterson]

Maybe you can copy the code from the shared workbook's project to another
workbook. Then tweak that code so that it works against the workbook/worksheets
you want (no references to ThisWorkbook!).

Then run the code from this "helper" workbook.

 

[Rodels]

Hi Dave,
Many thanks for the reply.

If I remove the shared option from the workbook and run it in "stand alone"
mode - everything works perfectly.

There must be something going on that shared environments don't like.

I am making extensive use of dynamic range creation, data manipulation
across sheets and various other functions that involve sheet protection etc.

Are there specific functions that Shared books don't like? I say again -
everything works perfectly in a single mode environment.

Using 2007 with all Service Packs installed.

Many thanks again!

Kind regards,
Robert
--
Kind regards,
Robert


Rodels! Creating weapons of Maths Destruction since 2003.

 

[Dave Peterson]

There's lots of things that shared workbooks don't like.

At least one problem is gonna be that protection (or unprotection) of sheets.
That's not allowed in shared workbooks.

Take a look at "features unavailable in shared workbooks" in Excel's (not VBA's)
help for a larger list.

 

[Rodels]

Thanks Dave,
As always, your help is much appreciated.
--
Kind regards,
Robert


Rodels! Creating weapons of Maths Destruction since 2003.