"With ActiveSheet" validation question
Thanks for the feedback
I will try to be clearer
When you open a DBF file in Excel, the tab at the botton is referenced with
the DBF name. No other sheets are available.
We have our DBF maint. macros in an XLS file. This is opened after the DBF.
If you where to open the XLS by it self the screen would be works sheet free
however the macros exist (VBA). This is because the default sheet in the XLS
has attributes to make it invisible / disabled as part of the properties.
Interesting the invisible sheets name is "Data" yet the ActiveSheet.Name
reports "Form" when it gets it wrong.
Regards
|