View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
robert morris robert morris is offline
external usenet poster
 
Posts: 222
Default Sheets in Workbook


Thanks,

Where would I enter the command to activate a sheet?

Bob M.

"JE McGimpsey" wrote:

Why do you hope that?

The worksheet tabs ARE just a toolbar:

Commandbars("Workbook tabs")

You can activate sheet "Sheet3" with

Commandbars("Workbook tabs").Controls("Sheet3").Execute

In article ,
"Bernard Liengme" wrote:

I hope you do not really mean "toolbar" but just the row of tabs at the
bottom of the worksheet window.