Removing annoying Detetion option box in Open Office

Category:

Office/VBA

Type:

Snippets

Difficulty:

Beginning

Author:

Bhuminder Singh Chauhan

Version Compatibility:

More information:

'Deletion in Open office Calc ( Spredsheet),write (word) is a problem due to the OPtion box that appears after clicking delete. 'Use this code to get rid of that and then assign it to a key 'like DEL so it will be easy to access.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:
'Just put it where the macros are in some module ' Works only in Open Office

Code: