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
|