Hi all - first post, love the site and thanks for all the great tips so far. Have used it a lot!
On the Mac (Excel 2011), I need to protect my VBA/macros from being able to be viewed. So, I have set the VBA Project Properties to 'locked' on the VBA (I know its not very security tight, but adequate for most of my users). All good so far.
My problem arises when I try to write a PDF workbook into one PDF file. I used Ron de Bruin's (very helpful) tip/workaround here: VBA code in Excel 2011 for the Mac (as the usual PC command ExportAsFixedFormatdoesnt work/has a bug). BUT for some reason I can only write a PDF combined file when the Project Properties are set to unlocked. Dont ask me why, but when its unlocked it works, when its locked it doesnt.
So, either
a) any suggestions for a fix or
b) is there a way to unlock the project properties at the start of a subroutine/macro and re-lock it at the end of a subroutine/macro?
Hope makes sense and any help gratefully received. I have been trying to fix this for days, and am getting desperate
thanks in advance, Ian
On the Mac (Excel 2011), I need to protect my VBA/macros from being able to be viewed. So, I have set the VBA Project Properties to 'locked' on the VBA (I know its not very security tight, but adequate for most of my users). All good so far.
My problem arises when I try to write a PDF workbook into one PDF file. I used Ron de Bruin's (very helpful) tip/workaround here: VBA code in Excel 2011 for the Mac (as the usual PC command ExportAsFixedFormatdoesnt work/has a bug). BUT for some reason I can only write a PDF combined file when the Project Properties are set to unlocked. Dont ask me why, but when its unlocked it works, when its locked it doesnt.
So, either
a) any suggestions for a fix or
b) is there a way to unlock the project properties at the start of a subroutine/macro and re-lock it at the end of a subroutine/macro?
Hope makes sense and any help gratefully received. I have been trying to fix this for days, and am getting desperate
thanks in advance, Ian
