Thanks again, that works great!
--
EW - Analyst


"Bernie Deitrick" wrote:

EW,

I mistakenly left in an extra .

Application.CommandBars("Cell").Controls.("Add reservation").Delete

should be

Application.CommandBars("Cell").Controls("Add reservation").Delete

If you already have a workbook_beforeclose event, then you need to modify the existing procedure
rather than add a second procedure of the same name.

HTH,
Bernie
MS Excel MVP


"ewagz" wrote in message
...
I seem to be having difficulties using the code and VBA is high lighting the
following code line:

Application.CommandBars("Cell").Controls.("Add reservation").Delete

I am also receiving the following error message when trying to run the macro:

Compile Error: Ambigous name detected: workbook_beforeclose

I'm using MS Excel 2000
--
EW - Analyst