Hi guys.
I have just spent days getting a spreadsheet ready to track our file circulation and now have hit a bloody wall.
I have had to protect some cells so there is no fiddling and the spreadsheet needs some vba to run to move details from one department (sheet) into the next department(sheet).
All works absolutely fine until I share the spreadsheet?
Is it not possible to share an protected workbook with vba? Sorry I'm pretty new to vba so any help would be greatly appreciated.
I must say that in my vba only the protected cells "unprotect" when data is being transferred, is this the issue?
Thanks in advance.
Pete
I have just spent days getting a spreadsheet ready to track our file circulation and now have hit a bloody wall.
I have had to protect some cells so there is no fiddling and the spreadsheet needs some vba to run to move details from one department (sheet) into the next department(sheet).
All works absolutely fine until I share the spreadsheet?
Is it not possible to share an protected workbook with vba? Sorry I'm pretty new to vba so any help would be greatly appreciated.
I must say that in my vba only the protected cells "unprotect" when data is being transferred, is this the issue?
Thanks in advance.
Pete