I have a workbook with four macros, all linked to Form Control buttons.
1. Creates a copy of the current worksheet.
2. Creates a copy of the current worksheet and selects and deletes data (basically creates a blank worksheet).
3. Selects and deletes data in a range.
4. Overwrites data in a different range.
If I run macros 1 or 2, I cannot run any additional macros on the same sheet until I have modified the sheet in some way (e.g. entering and immediately deleting text in a cell). I can run 3 and 4 without issue. Any idea why?
Bookmarks