combobox/copying sheet
 

Hi, we have a timesheet with comboboxes, we generally create copies of the
master sheet within the same workbook. Having comboboxes on the master sheet
and copying that sheet, when we try to use a combobox on the copy it kicks us
back to the master sheet. Is there a way to stop this. Any help would be
greatly appreciated.

Try "save as" instead of copy.

Carole O

"joe smith" wrote:

Hi, we have a timesheet with comboboxes, we generally create copies of the
master sheet within the same workbook. Having comboboxes on the master sheet
and copying that sheet, when we try to use a combobox on the copy it kicks us
back to the master sheet. Is there a way to stop this. Any help would be
greatly appreciated.

The problem is that we save with a copy to each sheet tab, but if you select
the combobox on one of the copied sheets it takes you back to the master
sheet. Save as is not an option when you are creating copies within the same
document.

"joe smith" wrote:

Hi, we have a timesheet with comboboxes, we generally create copies of the
master sheet within the same workbook. Having comboboxes on the master sheet
and copying that sheet, when we try to use a combobox on the copy it kicks us
back to the master sheet. Is there a way to stop this. Any help would be
greatly appreciated.