Can not save changed Macro
Hi SAP Gurus,
I am trying to change a macro in a workbook which has 2 queries in it and when I insert the new macro code its not allowing me to save it with the same name. The workbook says its a read only copy and save it with a different name, but this workbook was already in QA and Production and I dont want to create a new workbook with this changed macro. Please give me some suggestions here.
These are the steps I have done to change macro:
Open Bex Analyzer, Workbook and ran the workbook
Deleted all the data and then opened VB Editor, changed macro with the new macro, tried to save it and it says read only. I have installed the digital certificate and Signature key to edit the excel macros. Dont know what I am missing here.
Thanks in advance.
Message was edited by: Vinay Madhuri
If you change the Macro and try to save it in editor it will be save locally ..
Don't save the Macro ..After change made run the macro from from the tool bar ..it will atomatically save the macro changes..
Hope the above answer helps you..