| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shared workbook and Macro commands
I have a shared workbook and have written macro commands in it to select
specific data. The macro commands do not work at all. Can somebody help me? Is it possible to execute macro commands in a shared workbook or is there a way to do it? Thanks, Danie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Shared workbook and Macro commands
If the macro was written after you shared the workbook then my understanding
is that your stuck. have a look he- http://www.exceladvisor.net/sub/6_shared.htm Mike "Danie" wrote: I have a shared workbook and have written macro commands in it to select specific data. The macro commands do not work at all. Can somebody help me? Is it possible to execute macro commands in a shared workbook or is there a way to do it? Thanks, Danie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Shared workbook and Macro commands
Hi Danie,
Is it possible to execute macro commands in a shared workbook or is there a way to do it? Yes it is, although some things ar eblocked on a shared WB. BUT. I would advise against saring a workbook, Excel wasn't built as a multi-user application. You risk loss of data and corruption of your file! Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Shared workbook and Macro commands
You can't edit a macro in a shared workbook. But you can run them.
Maybe the macro tries to do something that isn't supported in shared workbooks??? Or maybe the user didn't allow macros to run (a security setting too high)??? Mike H wrote: If the macro was written after you shared the workbook then my understanding is that your stuck. have a look he- http://www.exceladvisor.net/sub/6_shared.htm Mike "Danie" wrote: I have a shared workbook and have written macro commands in it to select specific data. The macro commands do not work at all. Can somebody help me? Is it possible to execute macro commands in a shared workbook or is there a way to do it? Thanks, Danie -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Shared workbook and Macro commands
Thank you so much for all your help
"Jan Karel Pieterse" wrote: Hi Danie, Is it possible to execute macro commands in a shared workbook or is there a way to do it? Yes it is, although some things ar eblocked on a shared WB. BUT. I would advise against saring a workbook, Excel wasn't built as a multi-user application. You risk loss of data and corruption of your file! Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
| update pivot in shared shared workbook | Excel Discussion (Misc queries) | |||
| macro commands | Excel Discussion (Misc queries) | |||
| How can I get a validation to run in a macro on a shared workbook? | Excel Discussion (Misc queries) | |||
| Excel should allow macro on a shared workbook. | Excel Discussion (Misc queries) | |||
Linear Mode
