Search results

Hi there! The macro starts like this because it first deletes all the unnecessary columns, due to the standard spreadsheet export from SAP. So I have highlighted a row in "Total summary" tab which contains the formulas ( more or less ) for CHF currency. This should be generated for all the...

Hello kind Sir :) Thank you for the ClearData code, but that's not really the issue here. You can even ignore that button. I know everything looks messy because this macro has been recorded step by step, by another person. I am interested in finding out how to re-write the code for Module1 -...

Hi guys! Some of us, at work, are using this macro in order to run a revaluation report. The working file looks pretty ugly and the macro has been recorded and all apears to be a mess, so I have to re-write this as to be more user friendly. I would like to know if there's an easy way of...

Hi guys! so the test results: when I share the workbook, the macro behind does not work anymore :( any other idea?

One more question: If I share this workbook on our network, several user could run the macro, add comments and save data - all using the same file in the same time?

Hi again :) Thanks you for that link. So when i try to share the workbook "allow changes by more than one user at the same time" I get "Macros cannot be viewed or edited in shared workbooks" I was thinking it's still hope for somehow to share it. It would really help.

Hi everybody! I haven't found anything related to this issue so I gotta ask. I've made a macro which sorts data after windows username, so only user X can modify its cells and add comments. The thing is this workbook cannot be shared so, let's say...four persons uses it in the same time...