Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
programming command bars | Excel Discussion (Misc queries) | |||
Custom Command Bars | Excel Discussion (Misc queries) | |||
Command Bars | Excel Discussion (Misc queries) | |||
help! How do I restore command bars? | New Users to Excel | |||
command bars | Excel Programming |