View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default X button on userforms

If you protect the worksheet, you can tell excel not to allow the users to
select any cell:

Option Explicit
Sub testme()

Dim wks As Worksheet
Set wks = Worksheets("sheet1")

With wks
.EnableSelection = xlNoSelection
.Protect Password:="hi"
End With

End Sub




Nigel wrote:

Hi All
This appears so simple but...... how do you turn off the Excel cell cursor
or at the very least hide it?

--
Cheers
Nigel

"Greg" wrote in message
...
How do you disable the X button on userforms?

Thanks in advance

Greg



--

Dave Peterson