callbacksaveworkbook error

Question

When I use the shortcut ctrl+s to save a work book, an error pops up that says "Cannot run the macro 'CallbackSaveWorkbook'. The macro may not be available in this workbook or all macros may be disabled."

When I click on File > Save, it still saves. I just cannot use the Ctrl+s shortcut anymore... how do I fix this?

Answer 1

When I open the macro window, all the buttons on the right are grayed out. I cannot click on "create" to create this macro.

Hi Yang,

The commands for editing and running macros are located on the Developer tab, which is hidden by default. To show the Developertab, do the following:

• Click File, and then click Options.
• Click the Customize Ribbon category.
• Under Customize the Ribbon, in the Main Tabs list, click Developer, and then click OK.

For more information, you may refer to the following link:

http://office.microsoft.com/en-us/excel-help/edit-a-macro-HA102749024.aspx?CTT=1

Now:

Alt-F11 to open the VBA editor

Alt-IM to insert a new code module

In the new module, paste the following code

'==========>>

Public Sub Tester()

    Application.OnKey "^{s}"

End Sub

'<<=============

Alt-Q to close the VBA editor

Alt-F8 to open the macro window

Select Tester | Run

===

Regards,

Norman

Answer 2

When I use the shortcut ctrl+s to save a work book, an error pops up that says "Cannot run the macro 'CallbackSaveWorkbook'. The macro may not be available in this workbook or all macros may be disabled."

When I click on File > Save, it still saves. I just cannot use the Ctrl+s shortcut anymore... how do I fix this?

Hi Yang,

The Ctrl+s key combination has been assigned to a macro named CallbackSaveWorkbook

 which is no longer found.

To remove this assignment and restore the normal behaviour, try executing the following macro:

'==========>>

Public Sub Tester()

    Application.OnKey "^{s}"

End Sub

'<<=============

To execute the macro: Alt+F8 | select Tester | Run

===

Regards

Norman

Answer 3

You are amazing!

Thank you for your kind reponse.

Please would you now close the thread by marking my response as Answer.

===

Regards,

Norman

Answer 4

You are amazing!

Answer 5

When I open the macro window, all the buttons on the right are grayed out. I cannot click on "create" to create this macro.