Hi,

I have not got a clue about macros so any help will be greatly appreciated.

I need to create a macro that is attached to a button so that when this
button is pressed it saves the sreadsheet (the file name needs to relate to
the reference cell in the spread sheet) then this spreadsheet is attached to
an email so that it can be sent to whoever it needs to be sent to, you urgent
assistance on this will be greatly appreciated.

many thanks