Excel Sheet Click Event. It should do exactly as you want, firing any time the user clicks anywhere. [Edit: Dbb makes a very good point about the SelectionChange event not picking up a click when the user clicks within the currently selected cell. This code is added to one of the sheet objects in the Project.
Excel-vba Create new sheet on click with a name from a ... (Frank Hammond)
I would like to open an excel sheet, select a particular cell(by clicking on it) and then get its content in a variable using vbscript. Like other Excel protection settings, this is just a deterrent, or a navigation aid, rather than a security Click on the worksheet, and you will be restricted to clicking and scrolling in the Scroll Area. Place the code below into the Private Module of the active Worksheet, then.
Hidden sheets can be unhidden by any regular Excel user - by right-clicking in the worksheet tab area (shown above).
Compliance Tracking Spreadsheet pertaining to Software ...
Excel has no particular event handler for clicking in this way, but you could use one of the other Supriyo asked if there is a mouse event handler in VBA. ClickType - Specifies the type of mouse click (single, double, up, down) used when simulating the click event. This code is added to one of the sheet objects in the Project.