Thread: Command Bars
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_543_] Simon Lloyd[_543_] is offline
external usenet poster
 
Posts: 1
Default Command Bars

If you are creating a button you can assign a macro for that button t
call the help file, so if the help file is some text that you hav
entered in to a spreadsheet you have the button select this sheet whe
clicked. Below is a line to add to your auto open which will assign th
macro, when the button is clicked it will run this macro (sample below
of course you will change the "ABCD" and "Macro1" to the names in you
workbook

applicaton.CommandBars("cb_name").Controls("ABCD") .OnAction = "Macro1"

assuming macro1 is in the workbook where the above is run.

The line in your macro may read,

Sub Macro1()

Sheets("Help Sheet").Select

End Sub

Hope This Helps,

Simo

--
Message posted from http://www.ExcelForum.com