Warning messages, how to disregarde them?

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
Code:
On Error Resume Next
But this didnt seem to have much effect.

Any help would be much appriciated.

Thanks

Richard
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,114,674
Messages
5,549,358
Members
410,910
Latest member
DessertDiva
Top