View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VBA-Beginner VBA-Beginner is offline
external usenet poster
 
Posts: 1
Default URGENT!! PLEASE I NEED to finish this by 530 CT

I need to use a file exists statement to determine whether a command button
is visible or not on a spread sheet.

This is what I have come up with so far, but I am not sure of it or how it
actually works...

Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.FileExists("C:\Program Files\Hummingbird\DM
Extensions\Interceptor.exe")
Sheets("TIMESHEET").CMDBTN.Visible = a