grohm
04-17-2007, 06:28 AM
hi guys
well, its all about problems today, it seems, haha
I have written a vba script which locks some sheets of a workbook. this works perfectly. now if i put the whole thing on a sharepoint site, and open it up from there, it automatically disables the macros, leaving the sheet unprotected and free to view for everybody.
is there a way that i can force it to open up only with macros or not at all?
thanks for your efforts
greetz
ben
well, its all about problems today, it seems, haha
I have written a vba script which locks some sheets of a workbook. this works perfectly. now if i put the whole thing on a sharepoint site, and open it up from there, it automatically disables the macros, leaving the sheet unprotected and free to view for everybody.
is there a way that i can force it to open up only with macros or not at all?
thanks for your efforts
greetz
ben