VBA 執行 "按鈕(刪除)" 後，無法復原，程式碼怎寫才可以之後再復原

Question

VBA 執行 "按鈕(刪除)" 後，無法復原，程式碼怎寫才可以之後再復原

Andy Huang 20

有附上影片下載方便了解情況

https://drive.google.com/file/d/1Um83uYpQLgPvt3ZKsp7Qa2bpSdlmtxCA/view?usp=sharing

Thank you very much

0 則留言

由問題作者接受的回答

Kimberly Olaño 23,635

Hi Andy, this is Kimberly.

Ah, so in your case is deleted cell data, and you can’t undo it afterwards.

That’s expected because in Excel, once VBA runs and changes cells, Undo is disabled — there’s no built-in Ctrl + Z for VBA actions.

If you want to be able to “restore” the data after deletion, you need to save a copy of it before deleting, and then have a restore procedure that puts it back.

Should you have more questions, please let me know.

Best regards,

Kimberly

Andy Huang 20 信譽點數

2025-08-13T07:22:41.1766667+00:00
Hi Kimberly,

Thanks for the concept you provide.

Is it possible for Microsoft to upgrade the VBA so that undo is not disabled or

Is it sort of the nature so that "undo" is not possible ?

1 個其他答案

您的回答

Andy Huang 20 信譽點數

2025-08-13T07:22:41.1766667+00:00

Hi Kimberly,

Thanks for the concept you provide.

Is it possible for Microsoft to upgrade the VBA so that undo is not disabled or

Is it sort of the nature so that "undo" is not possible ?

Answer 1

熱情熄心冷 5,575

巨集通常是錄製大量動作，因此多數情況是不可復原，一般建議你執行前先儲存，以便復原。

0 則留言