Running invoice no. in Template used by multiple users

[impresxy]

Hi,

Can anyone share idea about using macro file by many user?

I have the macro template that can generate running invoice number and then save the template with new running no. The problem is that when there is more than one user open this template, the running number can be run but cannot save because another person is opening and the second person is on read-only mode. I know this can be best if I have access to store all data but at the moment the access is not available to use yet.

I cannot allow this template to be saved as new file once it is opened because it's required some fields before user can save it which it takes a while to do so. Thing is, it always possible that the second person will open this just right after the first person opens the template.

Please Login or Register  to view this content.

Please help

[:) Sixthsense :)]

Share the Workbook>>Alt+T+B

[impresxy]

Hi Sixthsense,

I have shared but it shows error and cannot view what is error. Please suggest.

[:) Sixthsense :)]

Please attach the screenshot of the error

[impresxy]

Error.jpg

Please see picture

[:) Sixthsense :)]

Applying/Removing of protection can't be done while the workbook is in shared mode That is the root cause of this error. Sorry for the inconvenience

[impresxy]

Hi,

Thank you. So then I cannot protect my file right?

Can you let me know of this code, when I remove me.unprotect and me.protect, shows error in red line.

Please Login or Register  to view this content.

[:) Sixthsense :)]

Instead of Selection.PasteSpecial type activecell.PasteSpecial and Type Opening Parenthesis ( which will show the remaining arguments needs to be supplied.

[impresxy]

Hi sorry where can I type (
It shows compile error, please let me know
Do i need any space or something to make it complete?
Thank you

[:) Sixthsense :)]

You just replace the text Selection.PasteSpecial by typing activecell.PasteSpecial( once you typed opening parenthesis you will get some methods how the paste needs to be done.

[impresxy]

Hi, sorry for not response as I have been trying with all methods in () after "activecell.PasteSpecial"
unfortunately none of them get it work.
I do not know what I did wrong

[:) Sixthsense :)]

May be try this...

Please Login or Register  to view this content.

[impresxy]

Hi

now it works but then I have to protect the sheet anyway right?

[:) Sixthsense :)]

Yes if you need...

[impresxy]

Thank you so much Sixthsense.