Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook before save
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook before save
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared workbook - to save or not to save | Excel Discussion (Misc queries) | |||
delete workbook from one location and save workbook to new locatio | Excel Programming | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Using interop.excel to open a workbook, the workbook doesn't ask to save changes. | Excel Programming | |||
What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming |