-
I'm not sure if it works the same way in 2007 as in previous versions, but isn't it possible for students to just open the workbook without enabling macros? Then they would be free to cut-copy or whatever they wished. I seem to recall a post elsewhere on this forum echoing this.. ah, here: http...
-
Hi Anonymous! This is how I would add a new worksheet and attach the "Calulate" event handler (the example shows a message box each time the calculate event is triggered): Private Sub NewSheet_Click() Dim oXl As Application: Set oXl = Application oXl.EnableEvents = False oXl.DisplayAlerts ...