richardcranney
New Member
- Joined
- Jul 15, 2006
- Messages
- 10
Hi there,
I have a Macro set up which unshares the workbook, runs a VBA script, then shares the workbook again. (I have to do this as the VBA doesnt work when shared)
Is it possible to turn off the dialog messages when sharing? I tried
But this didnt seem to have much effect.
Any help would be much appriciated.
Thanks
Richard
I have a Macro set up which unshares the workbook, runs a VBA script, then shares the workbook again. (I have to do this as the VBA doesnt work when shared)
Is it possible to turn off the dialog messages when sharing? I tried
Code:
On Error Resume Next
Any help would be much appriciated.
Thanks
Richard