PDA

View Full Version : excel and sharepoint 2007



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

grohm
04-17-2007, 06:41 AM
after checking Sharepoint for about an hour there is appearantely no way to force somebody to have the macros activated.

i dont know the difference between macros and real vba (i guess vba is always activated and not possible to deactivate and macros are possible to deactivate through macro security) but it might be an idea to do a check if macros are enabled per VBA before loading the workbook fully. if macros are not enabled, a msgbox should appear, telling the user to activate macros and retry.

is something like that possible?

greetz

ben