Friday, July 20, 2012

How Can I Disable All Double Clicking in Excel 2003?


1. Open the document you wish to disable double-clicking on in Microsoft Excel 2003.
2. Press the 'Alt' key on your keyboard and 'F11' key simultaneously. The VBA editor will appear.
3. Double-click 'Workbook' in the upper left window pane in the VBA editor. A new window will appear.
4. Copy and paste the following code into the new window:Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, _ByVal Target As Range, ByVal Cancel As Boolean)Cancel = TrueEnd Sub
5. Press 'Alt' and 'F11' simultaneously again to save the code and return to Excel. The string of code disables all double-click actions in the Excel workbook.

Blogger news