Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Gerritt Bakker   on Sep 15 In MS Office Category.

  
Question Answered By: Martha Gonzalez   on Sep 15

OK... is that what you were WANTING?
As I mentioned in my response, in the Before_Save event,
I checked the current userid to see if it was MINE.
If it was, I allowed a save.
If not, then I used cancel = true.

Another option would be to create a couple of subs:

Sub Event_Disable()
Application.EnableEvents = False
End Sub
'---------------------------------------
Sub Event_Enable()
Application.EnableEvents = True
End Sub

Use the Event_Disable to "turn off" event  handling.
Then you can save  the workbook.
(use Event_Enable to turn it back on for testing)

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Disable save from Ctrl S Or get search suggestion and latest updates.


Tagged: