I use vers 97
The VBA (macro) command to hide a sheet:
Sheets("Xxxxxx").Visible = True
Where "Xxxxxx" is the title of the sheet.
> Is it possible with VBA...to detect which version the user is
working on Thanks in advance,Louise
YEP.
Excel 97 also has version. I ran some experiments to see what I got
with various calls:
Debug.Print " Creator = "; Application.Creator
Debug.Print " OS = "; Application.OperatingSystem
Debug.Print " VERS = "; Application.Version
For some help, Go into menu > Tools > Oprions and turn on "Auto List
Members" Then type CTRL+Space to see all possible options with the
cursor in a module. And if you type "Application." it will now show
you a popup menu the plssible options for "Application.".