Richard,

Sounds like you want the code to run based on the
Worksheet that is currently active.
I do this all the time. Try this:
1. Take the code out of the Worksheet and put it in a
Module.
T
2. hen add this at the beginning:
mySheetName = ActiveCell.Worksheet.Name

3. Then find all the places in the existing code where
the name of a worksheet is hardcoded in and replace then
with:
mySheetName

4. Then from each command button click event, just call
the code.

Please let me know if you have any questions,
Ed

-----Original Message-----
Hello,
I have a workbook called Allotment which contains two
spreadsheets called All and Update.

Update has two CommandButtons called OptionA and OptionB.
In Update both buttons execute the code without a
problem.
I wish to be able to place both these buttons on sheet
All
and run then from there.

This is what I have done.

Opened control Toolbox in sheet Update and clicked on
the
OptionA button and selected copy. Then over to the All
sheet and clicked paste. Gone back to Update and copied
code over to the CommandButton in the All sheet.

When I click the command button in the All sheet, the
button is executing the code applicable to the Update
sheet within the All sheet. The first lines of code for
the Conmmand button delete cells in the Update sheet,
which is how it should, but when run from the All sheet
it
is deleting basically all of my sheet All, just leaving
some remnants of macro buttons etc.

What am I doing wrong. How can I drive the Update sheet
alone from the All sheet where I have copied the buttons
and code to. In other words the commands are executing
on
the wrong sheet.

Any help, please!
Thanks.
.