A
Arthur White
I have a button called "Load Job" (a macro) in a worksheet
that, when clicked on, launches a windows explorer OPEN box
to be able to browse and select a file. Normally, this
works fine, with the OPEN box popping up, showing the
default file location.
However, on 2 occasions now, on 2 different computers
running Excel 97 SR-2, I am getting the error "Compile
error in hidden module sheet 1" when the Load Job button is
clicked. One was with Windows 98, one with Windows 2000
Professional. Does anyone know why this might be happening?
that, when clicked on, launches a windows explorer OPEN box
to be able to browse and select a file. Normally, this
works fine, with the OPEN box popping up, showing the
default file location.
However, on 2 occasions now, on 2 different computers
running Excel 97 SR-2, I am getting the error "Compile
error in hidden module sheet 1" when the Load Job button is
clicked. One was with Windows 98, one with Windows 2000
Professional. Does anyone know why this might be happening?