Hi X Taol,
I am not sure which tab you want, but it should be possible to display the
required tab by using the dialogs collection, without recourse to SendKeys,
For example, if by 'adjustment tab' you mean the alignment tab, try:
Application.Dialogs(xlDialogAlignment).Show
The other tabs can each be accessed with one of the following instructions:
Application.Dialogs(xlDialogFormatNumber).Show
Application.Dialogs(xlDialogFormatFont).Show
Application.Dialogs(xlDialogBorder).Show
Application.Dialogs(xlDialogPatterns).Show
Application.Dialogs(xlDialogProtectDocument).Show
---
Regards,
Norman
"x taol" wrote in message
...
i want to select(focus) 'adjustment' tab in cell format dialog(ctrl+1)
using sendkey method only.
*** Sent via Developersdex http://www.developersdex.com ***