Hi,
I am opening an excel spreadsheet in my VB app as readonly. I just the user to be able to print it or save it as is without editing it.
The problem is that after they open the print or save as dialog and close it, the document is no longer readonly, they can then edit cells which causes problems because if they begin editing a cell and then click on a button to call a dialog an error returns from the automation object:
Call rejected by callee
So I need to know how to lock the document again after the dialog is called or how to deactivate the active cell that the user may be editing before the dialog is called.
Any help would be greatly appreciated.
Thanks,
- VB Rookie
I am opening an excel spreadsheet in my VB app as readonly. I just the user to be able to print it or save it as is without editing it.
The problem is that after they open the print or save as dialog and close it, the document is no longer readonly, they can then edit cells which causes problems because if they begin editing a cell and then click on a button to call a dialog an error returns from the automation object:
Call rejected by callee
So I need to know how to lock the document again after the dialog is called or how to deactivate the active cell that the user may be editing before the dialog is called.
Any help would be greatly appreciated.
Thanks,
- VB Rookie
