Hi All,
I have a macro that will setup and printout my report.
BUT before the report is printed I need the program to check if a cell has the correct value.
I am quite new to macros and would value any input.
I hope the following gives you an idea!
IF 'cell-value'='true'
THEN 'msgbox'
"Please add product range description!"
END
ELSE 'run print macro'
I also wish to change this cell content back after the print macro has finished.
Best regards
A.
I have a macro that will setup and printout my report.
BUT before the report is printed I need the program to check if a cell has the correct value.
I am quite new to macros and would value any input.
I hope the following gives you an idea!
IF 'cell-value'='true'
THEN 'msgbox'
"Please add product range description!"
END
ELSE 'run print macro'
I also wish to change this cell content back after the print macro has finished.
Best regards
A.