Hi

I'm fairly new to Excel Macroing and I've develeoped a spreadsheet which produces a report based on the information contained within a row. The user selects the row they want to make a report for, then click a button which runs a macro to copy the contents to each cell into a sheet called "Report", which has the layout of the report I print. The macro also opens Word and copies the cells which contain the report information into a blank document, then saves it with a sequential file name, before closing Word.

Is it possible to have the "Make Report" button greyed-out unless a specific field has been filled in? Essentially when the user selects the row they want to make the report for I want the macro to check if a specific cell within that row is blank or not, and if it is blank the "Make Report" button should be grey.

Any ideas?

Joe