View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
GS GS is offline
external usenet poster
 
Posts: 364
Default Disable the prompt when clicking on a protected cell?

Well.. I should have scrolled further down or used the dropdown. I don't use
it often, but this one works specifically for paths.

Function bPathExists(sPath As String) As Boolean
' Checks if a path to a folder exists.
' Arguments: sPath The full path to search
' Returns: TRUE if sPath exists

Const sSource As String = "bPathExists()"

On Error Resume Next
' "\nul" appended to the path makes it work with empty folders
bPathExists = (Dir$(sPath & "\nul") < "")

End Function

Regards,
GS