This tip (9151) applies to Microsoft Excel 2007, 2010, and 2013.You can find a version of this tip for the older menu interface of Excel here: Turning Off Screen Updating.Make sure that before ending the macro, however, you set the Screen Updating property back to True.
", _ vb Question vb Yes No vb Default Button1, "Freeze Sheets? Copy this macro into a regular code module, and run the macro to unfreeze all the sheets. If you want to set all the worksheets to the same zoom level, use this macro.
Okay, first I should mention that I'm a complete amateur when it comes to excel.
No VBA or macro experience, so if you're not sure whether I know something yet, I probably don't.
What I really need is a macro that will track any changes made to the departmental worksheets (Changes will be new rows added) and append those new rows to the end of the Master Worksheet.
Is there a way to monitor any changes made to these sheets & automatically copy new data to the first empty row of the Master sheet?