How come I haven`t thought of that:)Thank you,I must have gone blind:)It will
make a lot better

--
Regards,
Baha


"Bernie Deitrick" wrote:

Baha,

Why not just use a template? Then any changes are saved in a copy, not your original.

HTH,
Bernie
MS Excel MVP


"Baha" wrote in message
...
oHi all,
I have a worksheet with one code making merged cells and too many borders. I
want after user runs that code, they don`t save any of that.So basically I
want when you next time open "sheet1" no meged cells,print area clear and no
borders How can I prevent that. I tried tried writing a code in
workbook_save_before event to reset all the changes,but most users they don`t
know much about excel so they might click on cancel when they receive this
message "The selection contains multiple data values.Merging into one cell
will keep the upper-left most data only" Because when u click on cancel
delivers, debug error, wich they will all panick they did something:) So how
can I make my code works in both way without receiving this debug VBA error.
Thank you very much
--
Regards,
Baha