Mousless Users

Posted by John Graumann on May 23, 2000 1:24 PM

Suppose a user does not have access to a mouse. Some of the functionality of my workbook involves Command Buttons with macros tied to them, but Excel will not tab to these buttons ? Is there a way to tab to, and then click a button on a spreadsheet with no mouse ?

Posted by Ivan Moala on May 23, 2000 5:17 PM

John
Asumming excel'97 + AND commandbuttons as Activex
controls then in your commandbotton properties
under Accelerator assign a unique key or number
eg say commandbutton1 then in the accellerator
put in 1.
Your users can then activate this commandbutton via
Alt + 1 key

HTH

Ivan