Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: George Evans   on Oct 18 In MS Office Category.

  
Question Answered By: Kristen Chavez   on Oct 18

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.".

Share: 

 

This Question has 8 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Is it possible to detect Excel version? Or get search suggestion and latest updates.


Tagged: