In fact, you can do whatever mirroring without opening worksheets in fact the main worksheet, solve for you?
Att, Ulisses Flores לוהים הוא האש מכלה -----Mensagem original----- De: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] Em nome de PWS Enviada em: quinta-feira, 4 de fevereiro de 2010 13:14 Para: MS EXCEL AND VBA MACROS Assunto: $$Excel-Macros$$ BeforeSave - Enabling Macros Interesting situtaion which I sure others have come across before. I cannot think of a solution, I wonder if anyone else has or can? I have the requirement to not allow a workbook to be saved if a user has not entered information into a specified cell. I thought that is easy I will write a procedure which, using the BeforeSave event checks that the criteria (the cell has the required information) has been fulfilled and if not will cancel the save event. I wrote a nice warning box advising the user that the workbook could not be saved without the criteria being fulfilled and thought that was that. The first user who tried this opened the workbook, did not enable macros, and was therefore able to save the workbook without the required information because the Before Save event did not fire because macro had been disabled. I suppose I am asking is there any way to not open a work unless macro are enabled? PWS -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe