Hi Greg, thanks fro the reply, i created a menubar which has fou
buutons on it, for arguement sake lets say they are called today
tomorrow, yesterday and daybefore lets say the menuar is calle
everyday......should i replace your titles i.e "PHONELOGGER" with m
button name? i.e "TODAY"

I already turn the menubar on and off in auto_open/close
with
With Application
.CommandBars("Whateverday").Visible = True, but on opening a differen
workbook that also uses this bar i have to re-asign macros, then whe
opening the original again i have to re-assign again.

How do i actually assign the named macros to the named buttons on th
command bars in VBA in the auto_open?


Sorry for seeming a bit dense but ive only been at VB/VBa for about
weeks.

Simo

--
Message posted from http://www.ExcelForum.com