Disable close button on worksheet 1

[MatthewGB]

Hi,
Does anyone know how to diable the close button on a worksheet? I know how to do this for a userform, but I am not sure whether the same method can be applied to a worksheet, and also for the workbook.

Thanks

Matt

 

[Nikita6003]

Hiya,

perhaps this'll do:
choose TOOLS > PROTECTION > WORKBOOK, and check option WINDOWS only. Plz note - that'll remove ALL system items from the window


HTH

Cheers
Nikki

 

[MatthewGB]

Thanks for the quick reply Nikki. That was exactly what i was looking for. Doing it with code was also pretty straightforward, so workbook protection can be turned on when opening the workbook, and off when its closed.

A big star for you!

Cheers
Matt

 

[taupirho]

Matthew,

Can you tell me how you disable the close control on a userform? Thanks.

 

[Nikita6003]

Hiya,

just use the QueryClose event of the userform:

Private Sub UserFormName_QueryClose(Cancel As Integer, CloseMode As Integer)
  If CloseMode = 0 Then Cancel = True
End Sub

HTH

Cheers
Nikki

 

[taupirho]

Nikita, does the query_close method differ from the terminate method?

 

[Nikita6003]

Hi tomreid,

the 2 events are triggered at different moments. The whole list of event & their order:
QueryClose is triggered when the userform is being closed but is sitll available in memory
Terminate is triggered when the userform pbject is set to nothing i.e. is kicked out of memory

Cheers
Nikki

 

[MatthewGB]

Nikki,
You beat me to it!
That is the method I also use to disable the close button.
Once again, thanks for all your help with this problem and the problem in my other thread regarding the SaveAs function in Word.

Cheers
Matt