Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic in a shared workbook
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic in a shared workbook
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 wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic in a shared workbook
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" wrote: 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 wrote: 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic in a shared workbook
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 wrote: 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" wrote: 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 wrote: 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 . -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic in a shared workbook
Thanks Dave,
As always, your help is much appreciated. -- Kind regards, Robert Rodels! Creating weapons of Maths Destruction since 2003. "Dave Peterson" wrote: 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 wrote: 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" wrote: 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 wrote: 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 . -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Visual Basic update a Shared workook rather than autoupdate? | Excel Programming | |||
Find and Replace within workbook - from Visual basic | Excel Programming | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
How to hide a workbook and to detect a hidden workbook in visual basic | Excel Programming | |||
Saving Workbook in Visual Basic Hides the Worksheet, Why | Excel Programming |