Hi,

Set the ShowModal property of the userform to false

Mike

"Miree" wrote:

I had a lot of macro buttons

so put them into a user form so there was only one button on the sheet.

Is there a way that i can edit the cells with the sheet still open?