C
Cerberus
Is there a way to create a macro that if you double click on a cell or row it
will activate a worksheet. Example would be:
If cell A1 is double clicked, or at least activated and "submitted" using a
Command Button, the result would be:
Worksheets ("12").Activate
See I have 94 rows of assembly descriptions on a worksheet
[Worksheets("Start")], and 94 other worksheets that have a Bill Of Materials.
I would like to have a person be able to highlight a cell or row and it
brings up the correct BOM. A double click would be easiest on the end user
but I think an active row or cell with a Command Button is more achievable.
Any help is greatly appreciated. Thanks in advance.
will activate a worksheet. Example would be:
If cell A1 is double clicked, or at least activated and "submitted" using a
Command Button, the result would be:
Worksheets ("12").Activate
See I have 94 rows of assembly descriptions on a worksheet
[Worksheets("Start")], and 94 other worksheets that have a Bill Of Materials.
I would like to have a person be able to highlight a cell or row and it
brings up the correct BOM. A double click would be easiest on the end user
but I think an active row or cell with a Command Button is more achievable.
Any help is greatly appreciated. Thanks in advance.