Excel and commandbuttons

[Haldane]

New at VB so hope somneone can help. I have a spreadsheet used for Factory
Acceptance testing. There are 5 control/summary sheets any any number of
tests sheets - TEST 1,2 etc, which are added as required. I need be able to
have 1 set of commandbuttons that can be used on all sheets "Main Menu",
"Summary" "Check list" etc. without have to keep copy to each sheet manually.

Hope thats Clear?
Cheers HG

 

[Cindy M.]

Hi =?Utf-8?B?SGFsZGFuZQ==?=,

New at VB so hope somneone can help. I have a spreadsheet used for Factory
Acceptance testing. There are 5 control/summary sheets any any number of
tests sheets - TEST 1,2 etc, which are added as required. I need be able to
have 1 set of commandbuttons that can be used on all sheets "Main Menu",
"Summary" "Check list" etc. without have to keep copy to each sheet manually.

Put them in a TOOLBAR (Tools/Customize/Toolbars to create one;
Tools/Customize/Commands, Macro category, drag each macro to the toolbar to add
buttons).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail