Make sure that before ending the macro, however, you set the Screen Updating property back to True.
Remember, as well, that the Selection object (and the Select method) are not the only ways to access information.
Use this macro to freeze all the sheets in the active workbook.
", _ 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.
Thanks a lot, I'm already way closer than I would have been able to work out alone (I haven't dealt with any code since I was about 7, putzing around in BASIC for fun).
I changed the master sheet name to match my workbook, changed the ranges it selects to match my workbook, and took out the section for adding the sheet name before the data (don't need that), what I've got now is I think I need to change tracks here.
Many people write their own macros to manipulate the information in a workbook.
Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.