Undo / Redo Shortcuts & VBA

[TonySNZ]

Hi

In my workbook, I have disabled Formula Bar and Headings (from View). This file is password protected. Password. I have 'auto-hide' ribbon too.

However, by doing this, the 'undo' and 'redo' buttons that sits on the top in the "Quick Access Toolbar" disappears. Yes, we can always take our mouse to the top, which reveals the blank bar and quick tap on this will reveal the Quick Access Toolbar. This works ok but feel cumbersome.

As a substitute to this, can we, somehow, (a) place these 'undo' and 'redo' buttons on e.g. Cell B2? (b) if not, can we write VBA and create a Macro to assign 'undo' and 'redo' functionalities, and assign this macro to an object / button / Active X control button which then can be placed around Cell B2?

Your help would be greatly appreciated. Please let me know.

Regards
t

 

[Fluff]

Hi & welcome to MrExcel.
Why not just use the inbuilt short cuts? Ctrl Y and Ctrl Z

 

[TonySNZ]

Dear Fluff, apologies for the delay. Was away riding my motorbike in Easter holidays. Yes, I know this option is available but I wanted to create shortcut to provide good user experience. Imagine, there are 10 Slicers, and all have to be 'Undo", will take Ctrl + Z 10 times. Compare this with just one button. I hope you got my point. But, I think creating Undo Shortcut will be much harder and complicated than I previously thought. Thanks again. Regards t